Skip to main content



MonthDiff Function

The MonthDiff function returns the number of months between two Date values.

Syntax​

MonthDiff(start, end)

The MonthDiff function returns the number of months between two Date values.

Arguments​

start DateTime - The starting Date or DateTime expression.

end DateTime - The ending Date or DateTime expression.

Remarks​

Example:

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