Alert 3 months before the ending date I am using the Views and the Views conditional modules to display an alert message 3 months before the ending date is coming, but it does not work. For example the ending date is 12/10/2016(m/d/Y) and I want an alert shows before that 3 months such as 09/10/2016(m/d/Y). So this is my views



This is my Views condition
Looks like you're struggling with the issue about Date comparison not working.

You may want to try the steps explained in Comment # 20, to configure the timestamps.

If that doesn't work, then try what's suggested in Comment # 19, ie:


  Use the Views Date Format SQL module to format the date on the database server, prior to rendering by Views. This will allow for comparisons in Views Conditional.