Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 23, 2022 06:48 AM
Hi guys,
We have a field that lists the publish date + time for a piece of web content.
We want to be able to organise all of these dates into 'week commencing', ie. add a field that gives the date of the Monday of that week. So, an item published say on Thurs 22nd December 2022, falls into 'Week Commencing' 19th December 2022. Something published on Friday 23rd December 2022, also the same Week Commencing date.
The formula we're using to do this is:
DATEADD({CONTENT PUBLISH DATE},1-WEEKDAY({CONTENT PUBLISH DATE}),'days')
And it sort of works. But it seems to want to force some content pieces from the end of the week into the next week and I'm unsure why. For example, I have a piece of content dated for the 11th December 2022, 3pm, yet it forces it into week commencing 12/12/2022.
Any ideas why this might be?
Solved! Go to Solution.
Dec 23, 2022 10:43 AM
First make sure all timezones are the same.
Second - try this
Dec 23, 2022 10:43 AM
First make sure all timezones are the same.
Second - try this
Jan 05, 2023 10:32 AM
You sir, are a star, thank you! Happy New Year!