Skip to main content

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")

Was this article helpful?

We're sorry to hear that.