Skip to main content

Issue with DATETIME_FORMAT is showing the wrong date

  • March 26, 2023
  • 1 reply
  • 29 views
M
Forum|alt.badge.img+1

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 Attachments

1 reply

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • March 27, 2023

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

Terms & ConditionsAccessibility statement