Filter issues

How To
1

Issue with Sending Reminder Emails for Appointments in Make

I have set up a Make scenario to send reminder emails two days before an appointment. To achieve this, I applied a filter that compares the event date with the date two days from today. The condition should trigger only if both dates match.

However, the filter is not working as expected, and the emails are not being sent.

What I Have Tried

  1. Filter Condition:I used a condition like:

formatDate(appointment_date; “YYYY-MM-DD”) = formatDate(addDays(now; 2); “YYYY-MM-DD”)


  Goal: The condition should return `true` when the appointment date is exactly two days away.
  *Issue: The filter does not trigger, even when both dates appear to be the same.
2. Checked Date Formatting:
   The event date is coming from Google Calendar in **ISO format (YYYY-MM-DDTHH:MM:SSZ).
  * I tried formatting it into `YYYY-MM-DD` before comparison.
3. Verified Timezones:
  * `now` function in Make operates in UTC.
  * The event date may be in a different timezone (e.g., `+05:30`).
  * This could be causing a mismatch in the date comparison.

What I Need Help With

* Fixing the filter condition so it correctly compares the dates.
* Ensuring the reminder emails send successfully when the filter condition is met.
* Handling timezone differences properly to avoid mismatches.

Could you help me troubleshoot this issue? 🚀
2

Hey Nandini,

can you share the incoming bundle, a screenshot of the filter and a screenshot of how it is currently working?

If the issue is with different time zones in the google sheet and the make account, you can specify the time zone inside the formatDate() function.