DATEDIFF

The DATEDIFF function returns the number of days between two input dates. The input dates should be in MM/DD/YYYY format. Node references are also accepted as arguments.

Syntax

datediff(fromDate, toDate)

Arguments

fromDate – The start date of the interval.

toDate – The end date of the interval.

Return value

Number

Example

datediff('8/16/2023', '8/2/2023')

Returns 14.