Filter is "Today" at exact hour.
C
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.
W
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?
W
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