Alert 3 months before the ending date
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.