Functions (all)

Timespan

Function Name:
Timespan
Description:

Returns the amount of time between 2 dates in years, months or days.

Minimum FH Version:
4.0
No. of Parameters:
3
Return Type:
Number. The timespan in years, months or days..
Parameter 1:
First date.  If the date specifies a year, but no month, it will be treated as month 1.  If it does not specify the day, it will be treated as day 1.
Parameter 2:
Second date.  If the date specifies a year, but no month, it will be treated as month 1.  If it does not specify the day, it will be treated as day 1.
Parameter 3:

Must be one of the following values:

  • YEARS
  • MONTHS
  • DAYS
Examples:

=Timespan(%INDI.BIRT.DATE%, %INDI.DEAT.DATE%, YEARS)