Compares the difference between two dates - returning 0 if equal, -1 if date2 is less than date1 and 1 if the inverse
DateCompare(date1=[any], date2=[any], datepart=[string])
Argument | Type | Required | Description | Default |
---|---|---|---|---|
date1 |
any |
true |
The reference date object | |
date2 |
any |
true |
The date which to compare against date1 | |
datepart |
string |
false |
- ClearTimezone
- CreateDate
- CreateDateTime
- CreateODBCDate
- CreateODBCDateTime
- CreateODBCTime
- CreateTimeSpan
- DateAdd
- DateConvert
- DateDiff
- DateFormat
- DatePart
- DateTimeFormat
- Day
- DayOfWeek
- DayOfWeekAsString
- DayOfWeekShortAsString
- DayOfYear
- DaysInMonth
- DaysInYear
- FirstDayOfMonth
- GetNumericDate
- GetTime
- GetTimezone
- GetTimezoneInfo
- Hour
- Millisecond
- Minute
- Month
- MonthAsString
- MonthShortAsString
- Nanosecond
- Now
- Offset
- ParseDateTime
- Quarter
- Second
- SetTimezone
- TimeFormat
- Week
- Year