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

ARutledge
ARutledge Member
in Beast Mode

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?

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ARutledge
    ARutledge Member

    Thank you so much! It worked great.

Categories