friday night 17:00 to Monday morning 05:00

[ralphross]

Crystal 11
First of all thenk you very much ibass for last query.


Trying to get a report that only show the finished time from
friday 17:00
all day saturday
all day sunday
upto 05:00 monday

Need to see who is working at weekends afer 17:00 Friday

 

[lbass]

(
dayofweek({table.datetime}) in [1,7] or
(
dayofweek({table.datetime}) = 6 and
time({table.datetime}) > time(17,0,0)
) or
(
dayofweek({table.datetime}) = 2 and
time({table.datetime}) < time(5,0,0)
)
)

-LB

 

[ralphross]

Thank you ever so much Ibass worked a dream