Assign 'current' label to the latest 13 weeks [SOLVED]


#1

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!!


#2

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

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