Skip to main content

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

  • September 10, 2018
  • 1 reply
  • 5 views
L
Forum|alt.badge.img+2

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

    1 reply

    L
    Forum|alt.badge.img+2
    • Lety_Kemp
    • Author
    • New Participant
    • September 10, 2018

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

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

      Terms & ConditionsAccessibility statement