Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ArgumentTypeDescription
date1DateThe original date/time
date2Date FieldThe date to be subtracted from date1

...

Returns the number of milliseconds since 1pm on 1st January 2008.


round(dateDiff("20200410.000000", "20191217.000000")/(1000*60*60*24),0)

Returns the number of days between April 10th 2020 and December 17th 2019. The round() call removes any variance for daylight savings shifts.

See Also