Function DateCompare

Compares two dates

DateCompare([DATE_1],[DATE_2])

Parameters

# Type Passing Default Name Description/Comments
1 datetime required n/a DATE_1 The first date
2 datetime required n/a DATE_2 The other date

Returns

0 if the dates are equal, -1 if DATE_1 < DATE_2 otherwise 1


Examples

Compare two dates

{{DateCompare(ALIAS.STARTDATE,"01/01/2022")}}