I have read through the other posts on this topic, and nothing seems to work.
I set up a scenario to search records in the data store that were created 3 days ago to trigger a WhatsApp and email to be sent. When I initially set this up, it worked, but now it’s stopped. The data pulled is definitely and I am using the datetime operator. Although I have tried others to test this as well.
Can someone please let me know where I am going wrong? This is affecting several scenarios that are all data sensitive, and I have even tried by amending the date format to MM/DD/YYYY and voiding out the time to see if this would work.
Screen shot of fliter, return, and data store attached.
What you are currently doing is searching for a specific datetime down to the exact same second and millisecond, hence you aren’t getting any results because none of your records have the exact same millisecond as {{now}} - 3 days.
E.g.: now is 2025-03-14 at 20:54:42.135, so you are getting items that are at exactly three days ago 2025-03-11 at 20:54:42.135 (INCLUDING the exact same hour, minute, second, and millisecond).
To retrieve all items within the same day, your filter has to be a range, from a start of day to end of day.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
This is what I suspected. however I tried setting the fliter to Later than 2025-03-11 at 00:00:00 and earlier than 2025-03-11 at 23:59:59 but it still returned no results.
