Skip to main content

Filter by formula based on date and hour

  • June 18, 2022
  • 1 reply
  • 16 views
C
Forum|alt.badge.img+1

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?

T

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement