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()
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG