I need to scheduled monthly mail to user whose renewal days left 90, 60 or 30.
I made for 90 days but didn't get mail.
Please help
I believe these two sub-expressions never evaluate to TRUE at the same time
HOUR([DOMAIN END DATE] - TODAY())/24=90
[DOMAIN END DATE] = TODAY()
Simple arithmetic.
If [DOMAIN END DATE] = TODAY() is TRUE, then [DOMAIN END DATE] = TODAY() is ZERO. So HOUR([DOMAIN END DATE] - TODAY())/24 is ZERO <> 90
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |