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

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

Note: The following screenshot shows the acceptable date formats in Astera Data Stack.

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