If I see it correct the query runs every five minutes. Problem seems to be
"Follow up Date" = now()
now() contains also a timestamp part. If your Follow up Date is with timestamp it is unlikely that now and your datetime is the same (up to the second). If Follow up Date is only a date then the timestamp of this date is 12:00 am that usually is also not equal now() - only at midnight
try to use
"Follow up Date" >= startofday() and "Follow up Date" <= endofday()
Yes, but it is not working with now(). Use the query I stated above. StartOf Day() is today (12:00:00 am) and EndOf Day() is today at 11:59:29 pm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Giving the above query worked for 3 times.but again hung up showing this message "Scheduled rules are executed with respect to the server time: 19/03 9:26 PM".Please suggest
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I never have used this plugin. So I can't tell you much what that means. I suggest adding the corresponding tag for this plugin to this question. So it will get more visibility.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.