Skip to main content

Hello,



I’m trying to write a formula that assigns the status ‘current’ to the records of the current week plus 12 weeks prior to that. The intent is to always have a way to single out the latest 13 weeks, meaning, every week the oldest week should have a label changed to ‘past’ and the newest week be included in ‘current’.



I have used something similar for labelling days, but unsure how to always keep the latest 13 weeks status labeled.



Thanks!!

I have worked out how to do this with DATEADD… thanks anyway if anyone looked into this. 🙂



IF({Date Created} >= DATEADD({Record Created},-12,‘weeks’), “Current”, “Past Weeks ⏳ ”)


Reply