Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Re: Filter by formula based on date and hour

84 0
Showing results for 
Search instead for 
Did you mean: 

I’m using this filterByFormula which works perfectly fine based on date, but I want it to work based on hour as well. Just keep it the same way it is with hour functionality.

filterByFormula=IS_AFTER(LAST_MODIFIED_TIME(), DATETIME_PARSE("6/18/2022", 'locale'))

So for example for todays date which is 6/18/2022 be able to do 6/18/2022 20:00

What is the proper format to do it?

1 Reply 1

Hmm, could you try filterByFormula=IS_AFTER(LAST_MODIFIED_TIME(), DATETIME_PARSE('6/18/2022 20:00', 'M/DD/YYYY hh:mm'))?