# ToDateTimeOffsetFromDateTime (dateTime String)

| **Name**    | ***ToDateTimeOffsetFromDateTime***                                                                                                                                                            |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDateTimeOffsetFromDateTime (String dateTimeString, String offsetString)                                                                                                                     |
| Purpose     | To return date time with offset value after conversion.                                                                                                                                       |
| Description | Converts specified date time value to a date time with offset value.                                                                                                                          |
| Return Type | DateTimeOffset                                                                                                                                                                                |
| Parameters  | <p>dateTimeString \[System.String] – Date string which will be converted to datetime with offset</p><p>offsetString \[System.String] – Offset which will be added to datetime with offset</p> |

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

**Example**

In this example, we will pass a date time string value to the function transformation object using a *Variables* object.

Where,

*dateTimeString* = 2009 10 AUG 05:09:17 PM

*offsetString* = 10:00

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

In the output window, you can see that the provided date time string value has been converted to a date time offset value, of the specified *offsetString* value.

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