DateDifferenceHours (DateTimeOffset)

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

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.