Performs a full date/time comparison of two dates.
-1 if date1 is less than date2
0 if date1 is equal to date2
1 if date1 is greater than date2
[DatePart] yyyy: Year; m: Month; d: Day; h: Hour; n: Minute; s: Second
dateCompare(date1, date2 [, datePart])
returns numeric
date1.compare(date2 [, datePart])
| Name | Type | Required | Default | Description | Values | |
|---|---|---|---|---|---|---|
| date1 | date | Yes | A date to compare | |||
| date2 | date | Yes | Another date to compare | |||
| datePart | string | No | s | /Users/garethedwards/development/github/cfdocs/docs/functions/datecompare.md | s |
dateCompare('12/30/2015', '12/02/2015', 'yyyy')
Returns 1 because date1 is greater than date 2
dateCompare('12/30/2015', '12/02/2015', 'd')
d1 = createDate("2024","01","01");
d2 = createDate("2024","02","14");
d1.compare(d2)