Age (DateTimeOffset)
Name | Age With Offset |
Syntax | Age (DateTimeWithOffset start, DateTimeWithOffset end, Integer interval) |
Purpose | To compute the difference between two specified date time offset values, based on interval type (year, Month etc.) provided in integer form. |
Description | Compute the difference between two dates and return age in a specified interval. Valid values for interval: 1=Year, 2=Month, 3=Week, 4=Day, 5=Hour, 6=Minute, or 7=Second |
Return Type | Int64 |
Parameters | start [System.DateTimeOffset] end [System.DateTimeOffset] interval [System.Int32] |
Example
In this example, we will pass date time offset values, and an integer value (indicating a specific interval) to the function transformation object using a Variables object.
Where,
start = 01/03/2022
end = 06/06/2022
interval (3=week) = 3
In the output window, you can see that the provided interval value, indicating weeks, has been used to compute the age between the two specified date time offset values.