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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.