Skip to main content
Solved

Datetime format results add two minutes to time

  • March 26, 2024
  • 2 replies
  • 32 views
V
Forum|alt.badge.img+5

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!

Best answer by TheTimeSavingCo

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
V
V
Forum|alt.badge.img+5
  • VentureOutInc
  • Author
  • New Participant
  • March 27, 2024

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 - 

TheTimeSavingCo
Terms & ConditionsAccessibility statement