BeastMode to show an end date that is at least 6 month ago or older

ARutledge

I want to show records where the Program End Date is at least 6 months ago or older — in other words:

• Include: End Dates before or equal to 6 months ago
• Exclude: End Dates from 6 months ago up to today
• Exclude: Future End Dates

How can I write this in a Beastmode?

MarkSnodgrass

Depending on if you are looking for 6 months to the day or not, there are a couple ways to tackle this. One way would be to subtract 6 months from today's date and include or exclude. You could do it like this:

CASE WHEN mydatefield ⇐ DATE_SUB(CURRENT_DATE(), INTERVAL 6 MONTH) THEN 'Include'

ELSE 'Exclude'

END

This video may also be helpful to you in order to control the visibility of data based on dates

https://youtu.be/qxhV3gAZnk4

MarkSnodgrass

Depending on if you are looking for 6 months to the day or not, there are a couple ways to tackle this. One way would be to subtract 6 months from today's date and include or exclude. You could do it like this:

CASE WHEN mydatefield ⇐ DATE_SUB(CURRENT_DATE(), INTERVAL 6 MONTH) THEN 'Include'

ELSE 'Exclude'

END

This video may also be helpful to you in order to control the visibility of data based on dates

https://youtu.be/qxhV3gAZnk4

ARutledge

Thank you so much! It worked great.