DateDifferenceMonths (DateTimeOffset)
Last updated
Last updated
Name
DateDifferenceMonths with Offset
Syntax
DateDifferenceMonths (DateTimeWithOffset 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.DateTimeOffset] – 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/03/2024
rightDate = 06/06/2022
In the output window, you can see that the difference between the provided date time offset, and date time values has been displayed in the form of months.
