Skip to main content

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?

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


Reply