This cleaning step allows converting Text columns containing date values into Date Columns.

If you need a primer on types, please follow the Introduction to date types tutorial.

  1. Select one or many columns to convert

  2. Choose the input format of the input data. The following formats are available:

    • YYYY-MM-DD - for example, 1978-05-28

    • YYYYMMDD - for example, 19780528

    • M/D/YYYY - for example, 5/28/1978, or 10/28/1978.

    • D/M/YYYY - for example, 28/5/1978, or 28/10/1978.

    • M/D/YY - for example, 5/28/78, or 10/28/78.

    • D/M/YY - for example, 28/5/78, or 28/10/78.

  3. Select the option 'Convert non-dates to null' if needed. By default, the option is unselected and will display an error message if any value could not be converted as expected.

  4. Select the desired output date unit. Available units are:

    • Day

    • Week

    • Month

    • Quarter

    • year

Missing information in formats M/D/YY

Note that the formats M/D/YY and D/M/YY both have incomplete year information: The date 28/5/19 could refer to either May 28, 2019 or May 28, 1919. Workbench will interpret any data as representing years between 1970 and 2069.

For example:

  • 25/12/71 will be interpreted as May 25, 1971. Not May 25, 2017.

  • 25/12/19 will be interpreted as May 25, 2019. Not May 25, 2019.

Did this answer your question?