DAYS

Returns the number of days between two dates

Usage examples 

  • DAYS("1/15/2010", "1/10/2010")

  • DAYS(tableA.fieldB, tableA.fieldC)

Syntax 

DAYS ( end_date, start_date )

  • end_date - the end of the date range

  • start_date - the start of the date range

Returns 

number - the number of days between two dates

Functions reference