Convert text to date

User interface

General Principles Add text column Aggregate Append Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Cutom step Delete column(s) Duplicate Evolution Extract date property Extract substring Fill null Filter Formula Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Percentage Pivot Rename Replace Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot

Technical documentation

Steps Designing a new step Known limitations Translators Variables Custom code editor

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:

Mongo 4.0
Mongo 3.6

Where to find this step?

Widget Date
Search bar
Column header data type icon

Options reference

</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”). Please see the Mongo documentation for Mongo custom supported formats.

Example

This configuration results in: