DateDifferenceYears (DateTimeOffset)

Name

DateDifferenceYears with Offset

Syntax

DateDifferenceYears (DateTimeWithOffset leftDate, Date rightDate)

Purpose

To compute the difference between the specified dates in years.

Description

Subtracts a date time offset 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.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 years.

© Copyright 2023, Astera Software