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.

This expression returns 4:
DaysAfter( Date(‘2005-12-20’) , Date(‘2005-12-24’) )

Last modified: 23 May 2021