Time filters not working accurately

Hi, I’m not sure if the time filter is a new function, but I can’t seem to get it to work when we set it to “Is on or after” or “Is on or before”

When using Is after or Is Before, it works but in this manner:

Start time: 10:00 am
Choice selection shows: 10:30 am, 10:00 am is not selected. Filter columns are using the right time format.

image

Any idea from the community?

“Time” also has a date component to it (it’s actually a Date/Time column even if you format it to only show the time).

The best thing to do is to convert your time to a number (I.e. 10:00AM becomes 10.00; 2:00PM becomes 14.00), then use greater than or less than conditions to perform the filtering.

1 Like

Looks like your first filter is trying on a time level but the second one is on a date level? Can you confirm?

oops, it was supposed to be time and not date. this is the actual shot.

image

As @shchc said, datetime filtering also takes into account the underlying date. Do you only want to filter by the time part here?

Yes, just the time.

Funny thing is I use “is before/after” instead of “is on or before/after”, it works.

Lemme amend my app so that it can be shared.

If it’s time only then I think you can use two math columns to derive the hours from that time column and the now value to do a less than/greater than filter.

Testable here: https://rhetorical-zephyr-6058.glideapp.io/

Maybe this will explain it…

1 Like

I don’t have any further recommendations aside from reading what Mark wrote in the thread Darren linked above. Let us know if you need any further help.