Select records by time frame

[sfullergs]

I have a field named lwmain.dtrepor that has date and time in the same field. Basically, I need to select records for my report based on A) the year and B) the time frame of 10:00:00 PM - 2:00:00 AM (those times are also how the database formats the times) each day. So, for example, I need it to pull records for each day in 2018 but only records between 10:00:00 PM - 2:00:00 AM each day. I have other criteria already entered to further narrow the results. How would it be possible to do this? I am totally stuck. Thanks!

 

[lbass]

Assuming the field is a datetime field, you should be able to use:

(
Year({yourfield})={?Year} and
(
Time({yourfield})>= time(22,0,0) or
Time {{yourfield})< time(2,0,1) //Change the 1 to zero if you don’t want to include 2:00
)
)

-LB