Issue with DATETIME_FORMAT is showing the wrong date

[Maud]

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

[kuovonne]

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')