# 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FNKZPKJ3dGQggDYhO15KE%2F0.png?alt=media)

**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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FeKbum5IdhAScjKXOsgpf%2F1.png?alt=media" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F5dZkwJEqxwJ4eqaXQ45c%2F2.png?alt=media" alt=""><figcaption></figcaption></figure>

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FCnKmSnb20vV8YgmfjnQs%2F3.png?alt=media)
