That didnt seem to work. The closest I have come is by grouping by month the {tasks.opendate} using (@gmt to local) in the details then filter by technicial and work order type. Using the (@gmt to local) gets me the times in local time.
When I use your original suggesion I opened the selection expert and put it as a formula under {tasks.opendate}. It's not seeming to do any of the filters. Maybe I've confused it?
Below is everything that shows up in the selection expert. I dont know if that will help or not.
{TASKS.TYPE} = "Problem Call" and
{TASKS.OPENBY} in ["ABERTRAM", "ASAMPSON", "BCOY", "EMORAN", "GENERIC", "HELPDESK", "JRAMIREZ", "KTALIAFE", "MMACGILL", "RPAYNE", "VHAGERTY", "VOLSON"] and
(dayofweek({tasks.opendate}) in 7 to 1)
or (dayofweek({tasks.opendate}) in 2 to 6
and (hour({tasks.opendate}) in 17 to 24
or hour({tasks.opendate}) in 0 to 8))
Thanks!
Ginny =)