YEARS FROM Function
The YEARS FROM function returns the number of years between two date values.
The YEARS FROM function is similar to, but different from, the AGE function. AGE determines the number of years between a specific date and TODAY, but YEARS FROM is used when you need to be more explicit about both the start and end dates.
| Function name | YEAR FROM |
| Usage model | YEARS FROM ( start:DATE, finish:DATE ) |
| Parameters | This function requires you to replace two parameters: |
|
start: DATE |
The function determines the number of years between this date and the finishing date. |
|
finish: DATE |
The function determines the number of years between this date and the starting date. |
| Result | A number value. |
Example
In the following example, the YEARS FROM function finds the client’s age at the time of the hearing:
YEARS FROM( BirthDate, HearingDate )
In this next example, an expression uses YEARS FROM to determine whether or not the employee will have worked at the company for 25 years or more at the time of retirement:
YEARS FROM( HireDate, RetirementDate ) >= 25