To explain, I have a table which holds data on a bunch of courses that are being run in international locations - different times and timezones for each course. Your solution is great if I want a batch of rows to appear in the view at a single time defined by me.īut what I actually need is for each row to appear in the view at different times specified by a date-time in the row itself. That gets me a little bit of the way there, but actually, each row has a different time it needs to be triggered at. So I'm probably going to have to do an awkward workaround like create a field that counts the hours until the date (DATETIME_DIFF 'hours') and set the view to include when <48.īut its kinda bizarre that the filters don't have a more granular setting than days built-in to date filtering. I've tried using DATETIME_FORMAT to extract just the time - but there isn't a way to read that usefully in the view. So then I want the filter to register a new row at: 16:00:00īut instead, it ignores time, adding a new row at: 00:00:00 (as soon as it reaches the correct day basically) despite this being 16 hours early (but technically correct by 'days' alone).

However, that doesn't work as it doesn't include time in the calculation.

I set the filter to DATE = number_of_days_from_now = 2 I want to set up a view to trigger an external automation (zapier) exactly 48hrs before a specific date-time Has anyone else noticed that when creating a view and setting the filters (particularly on conditions relating to a date field that includes a time) there is no way to set the filter to read hours rather than days?

Zapier airtable filter