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

  1. Select the columns you want to convert to timestamp

  2. Choose the input format of your data: 

  • Auto will guess what that format is (default) 

  • United States Will only convert values with Month before Day, such as MM/DD/YYYY.

  • Europe Will only convert values formatted with Day before Month, such as DD/MM/YYY.

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.    

Output format

Currently, all timestamps are displayed in the format YYYY/MM/DD/HH/mm/ss.

Did this answer your question?