Thanks. Even though I was a little incorrect with my own question, this still enabled me to get to the correct answer. However, I misunderstood the business definition. I wonder if you may be able to assist me in tweaking the expression further.
In plain language, I want to:
Return a 1 if today's date is greater than the last stat_date plus the scheduled frequency days.
I.e. if the last check was 10.04.2022 and the scheduled frequency is 365 days, then it's out of date and should return a 1.
- However, there is a lead time as to when we receive updates on new status checks (stat_date). As a rule, the business don't want to include any checks that should have been done in the current calendar month, as they may have been completed but not yet recieved.
For example, the above stat_date for 10.04.2022 should be classed as Out of Date (1), but, as the check may have been completed this month, we may not have had the results yet. As such, I want to class all 'out of date' checks as 'In Date', as the check could have been completed recently - we just haven't had the results. I hope that makes sense. Any help would be gratefully received.
edit: in plain language:
if today's date is greater than the stat date plus the scheduled frequency, and that calculated date not occurring in the current month, return a 1. Else, return a 0.
