Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Day of Week and Date

Topic Labels: Dates & Timezones
1213 2
cancel
Showing results for 
Search instead for 
Did you mean: 
stmcmanus
4 - Data Explorer
4 - Data Explorer

How can i create a field that reads, for example, "Friday March 17, 2023" ?

2 Replies 2
stmcmanus
4 - Data Explorer
4 - Data Explorer

I would like to do this so that when I group by date, the header of each section includes day of week. For example, Friday March 17, 2023

Try adding a new formula field with the formula `DATETIME_FORMAT()` with the format specifiers you want 

Screenshot 2023-03-18 at 4.07.23 PM.png

DATETIME_FORMAT(
  Date,
  'dddd MMMM D, YYYY'
)