Help

Issue with DATETIME_FORMAT is showing the wrong date

Topic Labels: Dates & Timezones Formulas
2006 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')