Skip to main content

I have a formula in the primary field of my table that combines a Date/time and the name of the brand in the appointment.  Formula I am using:

 

DATETIME_FORMAT({Appointment Time},'MM/DD, H:MM A')&" - "&Brand
 
results are randomly adding 2, 4 and 6 minutes to the time format, ex:
04/09, 9:04 AM - Gregory
(appointment time is 9:00 am in the calendar column)
 
I'm lost, what am I not specifying that would prevent this?
 
Thanks!

Ah, you want to use "mm", not "MM".  "MM" returns the the month of the year, while "mm" returns minutes:

Here's a link to the date format specifiers too: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

Ah, you want to use "mm", not "MM".  "MM" returns the the month of the year, while "mm" returns minutes:

Here's a link to the date format specifiers too: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format


That solved it, thank you!  appreciate you taking the time to help - 

Reply


Terms & Conditions