...
Argument | Type | Description |
---|---|---|
date1 | Date | The original date/time |
date2 | Date Field | The 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.