I am using Airtable with Integromat, but am having issues filtering in Airtable using the TODAY() function.
I have a field in Airtable with a date (no time).
I have an automation in Integromat which runs every 15 minutes, searches my Airtable base using the filer IS_SAME({publication_date},TODAY())
I want my topic to publish at 12am every day GMT + 2 (CEST), but I can’t see a way of achieving this through Airtable, other than setting a specific publishing time, not just a date.
Does anyone have any thoughts on how to solve this?
I know I could probably create a formula in the filter that transformed GMT to GMT + 2, and filtered in this way, but it seems overkill…
any help much appreciated.