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

gbrown

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

Data_Devon

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?