Skip to main content

Datetime format for an upload

  • December 16, 2023
  • 1 reply
  • 48 views

Forum|alt.badge.img+2

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

Forum|alt.badge.img+2
  • Author
  • New Participant
  • December 16, 2023

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