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

Checking this option will convert any value that can't converted to the value 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?