Convert text to date

The Convert text to date step allows to cast a text column to date

Step parameters

• Column to convert column(string)*: the text column to be converted to date

• format (string)*: either Try to guess (the backend tries to infer the date format of your column), Custom (to allow you to enter a custom format in the custom format parameter below), or a preset (e.g. “%d-%m-%Y”).

Example

Input

Date - Convert text to date input

Configuration

{
    "date": "text_date",
    "format": "Try to guess"
}

Result

Date - Convert text to date output