Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Filter by formula based on date and hour

Topic Labels: Formulas
224 1
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'))?