This function compares two (date) values a and b. The return value is:
1 if a > b.
0 if a = b.
-1 if a < b.
Important note: If date values are to be compared, they must be "real" date values and not strings. For example, from a field of type "Date" or from one of the date functions.
Parameters
Parameter | Description |
|---|---|
a | (Date) value 1. |
b | (Date) value 2. |
Examples
Parameter a | Parameter b | Result |
|---|---|---|
23 | 45 | -1 |
45 | 23 | 1 |
33 | 3 | 0 |
2024-07-15 11:12:37.817 | 2025-07-15 11:12:37.817 | -1 |
2025-07-15 11:12:37.817 | 2024-07-15 11:12:37.817 | 1 |
2025-07-15 11:12:37.817 | 2025-07-15 11:12:37.817 | 0 |
aaa | bbb | 0 (Note: Internal typecast of both values to 0) |