Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 04/27/2021 in all areas

  1. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
    2 points
  2. 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!
    1 point
  3. 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.
    1 point
×
×
  • Create New...