DateDifferenceYears (DateTime)

Name	DateDifferenceYears
Syntax	DateDifferenceYears (Date leftDate, Date rightDate)
Purpose	To compute the difference between the specified dates in years.
Description	Subtracts a date time value from another date time value and returns result in years by dividing number of days by 365.2425.
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 years.