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

enter image description here

This is my Views condition

This is my Views condition

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.