Skip to main content



YearDiff Function

The YearDiff function returns the number of years between two Date values.

Syntax​

YearDiff(start, end)

The YearDiff function returns the number of years between two Date values.

Arguments​

start DateTime - The starting Date or DateTime expression.

end DateTime - The ending Date or DateTime expression.

Remarks​

Example:

YearDiff("5/1/2000", "6/1/2001"); // returns 1