DateCompare

Compares two dates to a given optional resolution.

Returns -1 if date1 is before date2. Returns 1 if date1 is after date2. Returns 0 if date1 and date2 are equal.

DateCompare( date1, date2 [, datepart ] )

Returns: Number

Argument Description Default
date1
datetime, required

date object; for example, now()

date2
datetime, required

date object; for example, now()

datepart
string, optional

Precision of the comparison:

  • s (default): Precise to the second
  • n: Precise to the minute
  • h: Precise to the hour
  • d: Precise to the day
  • m: Precise to the month
  • yyyy: Precise to the year

s

Examples

There are currently no examples for this function.

See also