Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Day of Week and Date

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