# ToDateString (DateTime)

| **Name**    | ***ToDate (String)***                                                                                                                       |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDate (String dateStr, String format)                                                                                                      |
| Purpose     | To convert a string into a date according to the given format.                                                                              |
| Description | Returns the resulting date time. Returns error if date cannot be converted.                                                                 |
| Return Type | DateTime                                                                                                                                    |
| 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(110).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/JUN/17

*format* = dd/MMM/yy

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(111\).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 value.

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