Skip to main content

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!
 
(Field on the left is the date of event, field on right is the "week" formula)

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

 

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.

Reply


Terms & Conditions