compare()
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.) |