Help

Need help changing formula to display "week of" month as a number rather than letter

Solved
Jump to Solution
1056 2
cancel
Showing results for 
Search instead for 
Did you mean: 
fordwitman
4 - Data Explorer
4 - Data Explorer

So I found a formula someone else made that does exactly what I need it to do.  I need to display the dates of certain events as "week of" so I can group the event by the week and see how many posts are made during the week.  The problem with the formula is it makes the "week of" appear as Apr 3, 2023, when I need it to say 04/03/2023.  The formula is: 

 

DATETIME_FORMAT(DATEADD(Date,1-DATETIME_FORMAT(Date,'E'),'day'),'ll')
 
Can someone help me out?  Thanks!
 
Screenshot 2023-07-26 at 11.57.49 AM.png
(Field on the left is the date of event, field on right is the "week" formula)
1 Solution

Accepted Solutions
BillH
9 - Sun
9 - Sun

If you change the 'll' to point 'l' you should get the result you need.

https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

 

See Solution in Thread

2 Replies 2
BillH
9 - Sun
9 - Sun

If you change the 'll' to point 'l' you should get the result you need.

https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

 

Thank you so much!  Worked like a charm.