# ToDateString (DateTimeOffset)

| **Name**    | ***ToDateTimeOffset***                                                                                                                      |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDateTimeOffset (String dateStr, String format)                                                                                            |
| Purpose     | To convert a string into a date according to the given format.                                                                              |
| Description | Returns the resulting date time offset. Returns error if date cannot be converted.                                                          |
| Return Type | DateTimeOffset                                                                                                                              |
| Parameters  | <p>dateStr \[System.String] – String representing date value to convert.</p><p>format \[System.String] – Date format to use to convert.</p> |

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

**Example**

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

Where,

*dateStr* = 15/13/MAR

*format* = dd/yy/MMM

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

In the output window, you can see that the provided *dateStr* value, of the specified *format* value, has been converted into a date time offset value.

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