Beastmode to flag an item if the date is longer than a week from the current date.

gbrown
gbrown Member
in Beast Mode

Hello,

I am trying to write a beastmode to 'FLAG' and item if the submission date is longer than a week from the current date. How would I proceed? See below for my current beastmode that flags something if it does not fall into the current week of the current date. My thought process is if the date is longer than the current day minus 7 days then 'FLAG'

CASE WHEN
WEEK(Submission Time) < WEEK(CURRENT_DATE())
OR
YEAR(Submission Time)!= 2025

then 'FLAG' ELSE 'NONE' END

Tagged:

Answers

  • Data_Devon
    Data_Devon Contributor

    You are on the right track. This should do the trick:

    I'd recommend removing the hardcoded Year reference so that this can be used eternally ☀️

    CASE
    WHEN `Submission Time` < DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
    THEN 'FLAG'
    ELSE 'NONE'
    END

    Did that do the trick?

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

Categories