Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Issue with DATETIME_FORMAT is showing the wrong date

Topic Labels: Dates & Timezones Formulas
2375 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Maud
4 - Data Explorer
4 - Data Explorer

Hello everyone, 

 

Quick question, I am using the formula DATETIME_FORMAT(Date, 'dddd d MMMM') to add the day of the week in may table (easier to fill in for the team if they know which day i.e., Monday, Tuesday, ... it is).

The issus is that the formula does not show the same value as the column date and loops between march 1st and March 6th.

Any of you had the problem ?

THANKS A LOT

1 Reply 1

The lowercase 'd' represents the day of the week. Replace it with a capital 'D' to get the day of the month.

DATETIME_FORMAT(Date, 'dddd D MMMM')