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

JarvisQ

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

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.