Help

DATETIME_FORMAT Formula Returning Incorrect Date (Sometimes)

Topic Labels: Formulas
1370 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Aly_Johnson-Kur
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to create a date column that includes the day of the week. I used the DATETIME_FORMAT formula, but it only correctly translates the date some of the time. In a number of cases it subtracts a week or more from the date column I’m referencing, which I hope to eventually hide. Any idea what’s going wrong? Here’s the formula I used: DATETIME_FORMAT({Go Live Date}, ‘dddd, MMMM do, YYYY’)

3 Replies 3
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

can you give an example of when it does not produce the correct result?

I.e. a screen shot of the input date and the output

Found a workaround, thank you!

Aly_Johnson-Kur
5 - Automation Enthusiast
5 - Automation Enthusiast

In case anyone has the issue in the future, the problem was in the formula. “do” returns day of the week. “Do” returns day of the month.

I used: DATETIME_FORMAT({Go Live Date}, ‘dddd, MMMM do, YYYY’)
Fix: DATETIME_FORMAT({Go Live Date}, ‘dddd, MMMM Do, YYYY’)