Help

Date Formatting Question

Topic Labels: Formulas
Solved
Jump to Solution
947 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SteelsmithHaus
6 - Interface Innovator
6 - Interface Innovator

Without going to Google sheets, how can I format an imported date/time from 2019-09-06 7:52 PM in the formula field to 9/06/2019 7:52 PM? Everything I’ve found just sets everything past 12pm to 12:00 AM. Also, is there something I’m missing using the regular date/time field? This doesn’t seem like a big stretch, but when I change the field type it just clears everything. Thanks!

1 Solution

Accepted Solutions
W_Vann_Hall
13 - Mars
13 - Mars

Take a look at the DATETIME_FORMAT() and DATETIME_PARSE() functions. Depending on your data source and process flow, you may need to use two fields, one to import as a text string and the other to convert to a datetime value (or vice-versa). In either case, you’ll use a format specifier to define how you want to read or output a date string.

Also keep in mind the ‘Use time field’/‘Use GMT’ toggles can be destructive, so don’t go flipping them randomly. They define how data is stored; they aren’t mere formatting options. If you change a time field setting and want to change it back, it’s best to ‘undo’ rather than simply flip the toggle again. (While figuring out how to configure dates when using live data, I usually duplicate the field in question, keeping an untouched version as backup.)

See Solution in Thread

1 Reply 1
W_Vann_Hall
13 - Mars
13 - Mars

Take a look at the DATETIME_FORMAT() and DATETIME_PARSE() functions. Depending on your data source and process flow, you may need to use two fields, one to import as a text string and the other to convert to a datetime value (or vice-versa). In either case, you’ll use a format specifier to define how you want to read or output a date string.

Also keep in mind the ‘Use time field’/‘Use GMT’ toggles can be destructive, so don’t go flipping them randomly. They define how data is stored; they aren’t mere formatting options. If you change a time field setting and want to change it back, it’s best to ‘undo’ rather than simply flip the toggle again. (While figuring out how to configure dates when using live data, I usually duplicate the field in question, keeping an untouched version as backup.)