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 01:50:30 AM
rightDate = 06/06/2022 01:50:35 PM
In the output window, you can see that the provided datetime values have been subtracted, and the output has been displayed in the form of hours.
Name
DateDifferenceHours with Offset
Syntax
DateDifferenceHours (DateTimeWithOffset leftDate, Date rightDate)
Purpose
To compute the difference between the specified dates in hours.
Description
Subtracts a date time offset value from another date time value and returns result in hours.
Return Type
Double
Parameters
leftDate [System.DateTimeOffset] – Date from which the other date will be subtracted
rightDate [System.DateTime] – Date which will be subtracted
