Skip to main content
Solved

Datetime format results add two minutes to time

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

View original
This topic has been closed for replies.

2 replies

TheTimeSavingCo
Forum|alt.badge.img+32

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 - https://thetimesaving.company
    Forum|alt.badge.img+5

    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 - 

      Terms & ConditionsAccessibility statement