Filter by formula based on date and hour

Topic Labels: Formulas
892 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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'))?