Get values with dates 3 months after the date in a field

I am trying to create a filter that shows a date in the month 3 months after a specified date.

 

For example, if I look at the card today I would like to see the values with 'end date' in January, 2019.  If I look next Friday on November 2nd, the filter would show values with 'end date' in February, etc..

 

I tried making an indicator using the case statement, but I was unable to create a range for January.  

 

What is the best way to do this?

Comments

  • bwardell
    bwardell Domo Employee

    You could use a beast mode similar to this: 

    (CASE
    WHEN `Order Date` > CURDATE()
    AND `Order Date` < ADDDATE(CURDATE(), INTERVAL 3 month)
    THEN `Order Date`
    END)

    Where curdate is the specific date that you want in a field.