Scheduled Task Email Not Sending

[JayDub]

Hi - I'm trying to send an email once a day to students that have registered in an upcoming class to let them know how to join the class. I created a task to retrieve the correct records and scheduled the task to execute each day at midnight. It should send emails to students in classes that begin in four days. I used this article as an example (Example 2: Event Reminder): https://howto.caspio.com/tasks/

I've attached my logic. The task runs successfully but no email is ever sent. If I change the Where Criteria to have the Course Start Date = the literal date I'm trying to target, and run the task, the email sends. But with the logic to test for four days out, the task runs but no emails are sent. Any thoughts are appreciated.

[kpcollier]

Hi @JayDub,

Have you tried swapping the timestamp and CourseStartDate fields? "WHERE CourseStartDate EQUALS TimeStamp - 4 days'

You could also try the 'difference in days' block under Date. 'WHERE difference in days between CourseStartDate and Timestamp equals -4'

I have not been able to test these, but thought I would try to help.

[sandy159]

Hello @JayDub,

The previous comment by kpcollier is absolutely correct. The email may not be sent because the WHERE condition is not met.

I usually like to use the 'difference in days' block for this type of task. Basically, if a field with a date is in the future - then the Timestamp should be set in the first place. That said, to select the records with classes that begin in four days, the difference in days should be equal to 4.

Here is the example, just swap the fields to yours:

Hope this helps!

[JayDub]

Thanks @kpcollier and @sandy159. I will try the difference in days option and let you know if it works. It's strange to me, though, that the example Caspio uses in their post about tasks, which is illustrating essentially what I'm trying to do, uses the other method, which (unless I'm missing something) does not seem to work!

[JayDub]

Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.