DateDifferenceMonths (DateTime)

Name	DateDifferenceMonths
Syntax	DateDifferenceMonths (Date leftDate, Date rightDate)
Purpose	To compute the difference between the specified dates in months.
Description	Returns difference between the specified dates in months by dividing number of days by 30.4375.
Return Type	Double
Parameters	leftDate [System.DateTime] – Date from which the other date will be subtracted rightDate [System.DateTime] – Date which will be subtracted

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/01/2023

rightDate = 01/02/2022

In the output window, you can see that the difference between the provided datetime values has been displayed in the form of months.