Wednesday, March 7, 2012

Expression - Compare dates

How can I check if:

Date1 is newer than Date2?

Thank you! Smile

Use the greater than (>) operator, e.g.

Code Snippet

@.[User::Date2] > @.[User::DateTimeVar]

|||

If you are using the Script Component, then we can check this way here

If Datediff(DateInterval.Day, Date1,Date2) > 0 then

....

End If

Thanks

Subhash Subramanyam

|||

And check if the 2 fields are realy datetime type, if not you need to convert it first.

Regards!

|||thank you.

No comments:

Post a Comment