So i have an app which tracks all of our contracts with our customers. they all have an expiration date and the report shows the amount of days until the said contract is expiring. I wanted to create a email notification to email me anytime a contract is within 10 days of expiring. So far it has not been working. Here is how i have it setup:
Notify when 'a contract is modified' and when 'specific field changes' -days to expiration- AND when the following conditions are true after the change:
all of these conditions are true 'days to expiration is equal to the value 10 days'.
How to i set it up so it just says email me when days to expiration is equal to the value 10 days.
I have tried changing the all to any. Which did not work either.