Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 09, 2019
I have a base where I need to produce a report/view each day between 05:00 - 05:00 rather than a midnight to midnight (yesterday) view.
Each entry has a Opened Date field which includes the time in the field.
Is there a formula which I can use to extract the time element so that only records created in the last 24 hr period are shown between 5am - 5am?
Hopefully that makes sense?