Make + Airtable Scheduled Notifications Not Working Due to Time Zone Problems

Other Questions Airtable
1

Issue Description:

Hey everyone!

I have a setup with Make and Airtable where I want to trigger notifications 15 minutes before an event time. Users input their time data (in IST timezone) into a field I call Event_Time_Input.

I created a calculated field Notification_Time in Airtable using this formula:

IF(
  {Event_Time_Input},
  DATETIME_FORMAT(
    DATEADD(
      DATETIME_PARSE({Event_Time_Input} & ' +05:30'),
      -15,
      'minutes'
    ),
    'YYYY-MM-DDTHH:mm:ss\Z'
  )
)

Then in Make’s “Find Records” module, I use this filter condition:

AND(
  IS_AFTER(DATETIME_PARSE({Notification_Time}), DATEADD(NOW(), -15, 'minutes')),
  IS_BEFORE(DATETIME_PARSE({Notification_Time}), DATEADD(NOW(), 1, 'minutes')),
  NOT({Notification_Sent})
)

The logic seems right to me. The Notification_Time field shows UTC format, and Make’s NOW() function also returns UTC time. The time calculations appear to match up correctly.

But here’s the problem - the search returns zero results even when there should be matching records based on the timing.

Has anyone dealt with similar timezone issues in Make and Airtable integrations? Any ideas what might be going wrong here?

Thanks for any help you can provide!

2

had the same problem b4! i found dat instead of +05:30 in the airtable formula, using SET_TIMEZONE might do the trick. also check if make’s timezone settings are correct, that could be causing the issue too.