Skip to main content

Datetime format for an upload

  • December 16, 2023
  • 1 reply
  • 2 views

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. 

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


Reply