Expression

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.

16481187781608526914907112651091.jpg

 Please help

0 1 55
1 REPLY 1

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

Top Labels in this Space