Qrew Legendnp, we can help. Can you tell us the field type that you are dealing with to hold these dates and times. Can you tell us the field types that hold the data?
If you have a field which is already a Time Of Day field type you can use this formula.
[My time of day field] >= ToTimeOfDay("12:00 pm")
and
[My time of day field] <= ToTimeOfDay("4:00 pm")
I have a Time of Day field (Sched Dept) and a numeric formula for Hour. I'd want to restrict either one of those to restrict files within those hours.
It worked! Sometimes the simplest things trip you up. Thanks for the help!
