Update date value if only it is greater

[mzwai]

Please help in writing a script that will update a field(date value)only if the date value imported from a spreadsheet via Connect is greater than the value in the AM db.

[tis_itsm]

You can compare the incoming value from excel sheet with the value available in AssetCenter.

You can code this comparision in ConnectIt script using PifExecODBCSql or PifNewQueryFrmFormatName functions...

HTH !

[antoineb]

Maybe you can use "Reconciliation scripts" with vNewVal and vOldVal variables, directly in Connect-It.
In your script for your date field :

if DateDiff(vOldVal,vNewVal)> 0 then
RetVal = vNewVal
else
RetVal = vOldVal
end if