Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 26, 2023 02:41 PM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 26, 2023 06:56 PM
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')