ToDateTime function

The ToDateTime function converts the value to its left to a date and time. This function is available for float, integer and string columns.

This function uses the following parameter:

Culture: Optional; only used when converting from a string. Use this parameter to specify the formatting used to display the date according to the locale of the user. Valid values for the Culture parameter are pulled from .NET’s list of available culture codes. When you edit the function using the Statement Editor interface, a number of commonly used values will display when you select the Culture field. You can select a value or type the value you need. You can also add the Culture value using the Statement Text Editor.

The string format that the function can convert to a date will be one of the formats that .NET can parse for the specified culture. If you need to convert data that doesn't parse by any normal culture code, then you need to take apart the string and convert individual parts to date parts before combining them.