# ToDate (String dateStr)

| **Name**    | ***ToDate***                                                                                                                      |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDate (String dateStr)                                                                                                           |
| Purpose     | To return a date converted from a string.                                                                                         |
| Description | Converts string into a date using the current culture. Either returns the converted date or returns null if the conversion fails. |
| Return Type | DateTime                                                                                                                          |
| Parameters  | dateStr \[System.String] – A string containing date in the local culture format                                                   |

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

**Example**

In this example, we are passing a date time value in a format NOT present in the acceptable date time formats list in Astera Data Stack, to the function transformation object using a *Variables* object.

Where,

*dateStr* = MAR.8.22

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

{% hint style="info" %}
**Note:** The following screenshot shows the acceptable date formats in Astera Data Stack.
{% endhint %}

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

In the output window, you can see that the provided string has been converted into an acceptable DateTime value.

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