Skip to main content

​
Description

Returns the number of years between the end_datetime and the start_datetime.

​
Syntax

DateDiffYears(end_datetime, start_datetime)

​
Arguments

end_datetime - string expression in ISO 8601 format. start_datetime - string expression in ISO 8601 format.

​
Examples

DateDiffYears(’2009-01-07T01:07:01.000Z’,‘2008-02-01T00:00:00.000Z’) returns 0

​
Notes

end_datetime and start_datetime must be in ISO 8601 date time format, otherwise the job will fail. See Using ISO 8601 date/time functions.

​
Return value datatype

Long

​
Impact of null value

If any (or all) inputs are null, returns null.
Last modified on April 20, 2026