# 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  | <p>leftDate \[System.DateTimeOffset] – Date from which the other date will be subtracted</p><p>rightDate \[System.DateTime] – Date which will be subtracted</p> |

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(102\).png)

**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

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(103\).png)

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.

<figure><img src="https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20(103).png" alt=""><figcaption></figcaption></figure>