Help

Datetime format results add two minutes to time

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
395 2
cancel
Showing results for 
Search instead for 
Did you mean: 
VentureOutInc
4 - Data Explorer
4 - Data Explorer

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!
1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-03-27 at 6.32.12 AM.png

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-03-27 at 6.32.12 AM.png

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 -