Age (DateTime)
Last updated
Last updated
Name
Age
Syntax
Age (Date start, Date end, Integer interval)
Purpose
To compute the difference between two specified date time values, based on interval type (year, Month etc.) provided in integer form.
Description
Compute difference between two dates and return age in 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.DateTime]
end [System.DateTime]
interval [System.Int32]
Example
In this example, we will pass date time values, and an integer value (indicating a specific interval) to the function transformation object using a Variables object.
Where,
start = 01-01-2022
end = 05-10-2024
interval (4 = day) = 4
In the output window, you can see that the provided interval value, indicating days, has been used to compute the age/difference of days between the two specified date time values.
