Help

Extract time from Opened Date Time

Topic Labels: Formulas
746 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Hawkes
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

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?

Many thanks,

Jason…

0 Replies 0