Help

Datetime format for an upload

Topic Labels: Dates & Timezones Formulas
360 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AMSpicerDesigns
4 - Data Explorer
4 - Data Explorer

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to add the comma in. 

1 Reply 1
AMSpicerDesigns
4 - Data Explorer
4 - Data Explorer

Obviously not braining last night. Figured it out this morning using DATE_FORMAT. All is well.