# ToDateTimeOffset (String dateTimeOffsetStr)

| **Name**    | ***ToDateTimeOffset***                                                                                         |
| ----------- | -------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDateTimeOffset (String dateTimeOffsetStr)                                                                    |
| Purpose     | To return the converted date time with offset using the current culture format.                                |
| Description | Converts string into a date time with offset using the current culture. Returns null if the conversion failed. |
| Return Type | DateTimeOffset                                                                                                 |
| Parameter   | dateTimeOffsetStr \[System.String] – A string containing date time with offset in the local culture format     |

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

**Example**

In this example, we will pass a date time offset value, NOT in the current cultural format, to the function transformation object using a *Variables* object.

Where,

*dateTimeOffset* = 2020 25 JUL 11:02:09 AM +05:00

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

In the output window, you can see that the provided date time offset value has been converted to a date time offset value in the current cultural format.

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