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.

© Copyright 2023, Astera Software