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 Join Keep column(s) Percentage Pivot Rename Replace Sort Split column 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

Options reference

Column to convert:: the text column to be converted to date
Date format:: (optional). By default, the backend tries to guess the date format of your column. But if needed you can specify here a custom format.

Please see the Mongo documentation for Mongo supported formats.

Example

This configuration results in: