Convert text column to date

You can use this step to cast a text column to date.

This step is supported by the following backends:

  • AWS Athena
  • Google Big Query
  • MySQL
  • PostgreSQL
  • AWS Redshift
  • Snowflake
  • Pandas
  • Mongo 5.0
  • Mongo 4.2
  • Mongo 4.0
  • Mongo 3.6

Where to find this step?

  • Widget Date
  • Search bar
  • Column header data type icon

Options reference

</br>

</br>

</br>

  • Column to convert:: the text column to be converted to date

  • format:: 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”).

    Depending on your backend, see the adequate documentation for supported custom formats:

Example

This configuration results in: