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?


  • bwardell
    bwardell Domo Employee

    You could use a beast mode similar to this: 

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

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