Function reference
Return the number of days one date occurs after another.
DaysAfter ( date1, date2 )
| Argument | Description |
| date1 | A date value that is the start date of the interval being measured |
| date2 | A date value that is the end date of the interval |
Data type: Long
Returns a long containing the number of days date2 occurs after date1. If date2 occurs before date1, DaysAfter returns a negative number.
Example
This expression returns 4:
DaysAfter( Date(‘2005-12-20’) , Date(‘2005-12-24’) )
Last modified:
23 May 2021