1. Select the columns you want to convert to date

  2. Choose the input format of your data: 

  • Auto will guess what that format is (default) 

  • Date (U.S) Will only convert MM/DD/YYYY values

  • Date (E.U) Will only convert DD/MM/YYYY values

Convert to non-dates to null

When checked, the step will convert any value that can't be converted to  null .

If unchecked, specific error messages will inform you about which value in which column cannot be converted.    

Display formats

Right now, all dates and times are displayed in the format YYYY/MM/DD/HH/mm/ss

New display formats will be available soon! In the meantime, feel free to drop us a quick line in the messenger and tell us about your need 👍

Did this answer your question?