Calculating Only After Hours & Weekend work

[dugan22]

I need to show only after hour calls to our support people starting at 6 pm on a Friday and ending at 8 am Monday. Whats the best way to do this on a date-time field (OpenedOn)? I've been tooling around with setting the time for the 5,6,7 and 1 days but I seem to keep bringing in the wrong records. I need to show work that is done after the working week is over. Any advice would be appreciated


Mike

 

[synapsevampire]

Try something like:

(
day({table.date}) in [6,1]
)
or
(
day({table.date}) = 5
and
hour({table.date}) >= 18
)
or
(
day({table.date}) = 2
and
hour({table.date}) <= 8
)

May be some difficulties with the Time function, I can't test right now, so some conversion there might be required.

-k