JDiff

Use this function in an equation to calculate the number of days between two specified calendar dates.

Syntax

JDIFF (SymName|"Date1", SymName|"Date2"[,"Format"])

where:

• SymName is a TIMEPER symbol representing either a start or end date for the range.
• Date1 is the start date of the range.
• Date2 is the end date of the range.
• Format is the format of the dates to be compared. The default is “yyyy-MM-dd hh:mm:ss”.

Syntax example

JDIFF ("2007-05-06", "2007-12-31")