Filter is "Today" at exact hour. | Voters

Filter is "Today" at exact hour.

We Have A Tender

We will need ability to filter the records by exact hour. The "Today" option is not sufficient in our workflow.

February 16, 2025

Colleen Deal

Here's a workaround for you in the meantime:
For the First Created field, modify the field settings to "include time." Then, create another field called AM/PM that will have the following formula:
IF(CONTAINS([First Created],"AM"),"AM","PM")
Then, you can filter by the AM/PM field and the date the record was created.
There also is an “hour” formula that could you use in your new field but for your purpose of just wanting morning/afternoon, that might be a lot more to then have to select in your filters.

We Have A Tender

Colleen Deal Fabulous!

Jon Darbyshire

Hiya We Have A Tender, thanks for this post! I have a few more questions for you:

What specific use cases or scenarios require filtering records by exact hour?
How frequently do you anticipate using the exact hour filter in your workflow?
Are there any specific time zones or time formats that need to be considered for the exact hour filter?

We Have A Tender

Jon Darbyshire Hi Jon 🙌

We are importing couple of records every day and filtering by created today is not enough for us to clearly see only the records imported in the morning and being able to bulk edit them.
everyday multiple times
no

Photo Viewer