get-months-from-date-difference

Calculates the difference between the months part of two given date and time values and returns the difference.

Syntax

    get-months-from-date-difference(strDate1,strDate2)

Parameters

strDate1 is a string that represents one date to compare and is specified in the format yyyy-mm-dd.

strDate2 is a string that represents the other date to compare and is specified in the format yyyy-mm-dd.

For more information about date and time parameters, see Date and time parameters.

Returns

A number that holds the difference between the months part of the given date and time values.

Example

The following expression returns a number of value 11:

    get-months-from-date-difference('2000-10-30','1999-11-28')