In this example we are converting “Wednesday, October 3, 2012” to a datetime data type on the platform. Where %A represents the full text of day of the week, %B the full text of the month, %e as a non-zero padded day in a month, and %Y as the four-digit representation of the year.
- After you have uploaded a dataset, but before publishing, open the date column drop-down menu and select "Data Transforms."
- Use the
to_floating_timestamp(text, text), that accepts two text string values, to transform the date text string to a date.
The first text string will be the date, or date column, that is to be transformed. The second text string will specify what format the date from the source file is coming through as.