© Copyright 2023, Astera Software
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.
