CompareDateTime

The CompareDateTime()/ function compares two date values and returns a numeric value as a result.

• for date 1 > date 2, the function returns 1
• for date 1 = date 2, the function returns 0
• for date 1 < date 2, the function returns -1

CompareDateTime('Date1', 'Date2')

CompareDateTime(@EntryDate, '2007-01-29T17:50:00')

Returns -1, 0 or 1 zurück