Restrict data to after Business hours only...

[Former Member]

hi all,

I am trying to ascertain how many services calls are logged to a particular workgroup made after business hours i.e. after 6.00 pm(18:00hrs) and before 7am (07:00hrs), each day for past 2 months.

so how do i restrict the data only between these times.

i am confused as 7.00am fall on the next day early morning.??? thus data is restricted to from 6 in evening to 7:00 hrs next day in morning.

any inputs or ideas will be highly appreciated mate..

regards

abhi.

[Former Member]

Use a record selection formula that ONLY pulls times (hopefully you have a date time field) that are between 6pm and midnight OR between midnight and 7am.