How to report surgical cases that occur after hours and on weekends 1

[puddinpop]

Hi there,

I am a basic level Crystal user. I still have alot to learn.

I have been asked to create a report that will return surgical case information on cases that were performed after regular business hours and on weekends.

Our regular business hours are 07:00 -15:30 - Monday to Friday.

I figured out how to return cases that have a Start Time > 15:30 but this doesn't include the cases that occur between midnight and 07:00. I also don't know how to make it so that the report will return ALL cases for Saturday and Sunday.

Any pointers would be greatly appreciated.

this is my first time asking for help so I apologize in advance if I did not include enough information.

Thanks!

 

[IanWaterman]

Function dayofweek(DATEFIELD) returns day number

so you can use dayofweek(DATEFIELD) in (1, 7) to test for sunday and saturady respectively.

For your time

you alraedy have a condition for Start Time > 15:30 just wrap in brackets and use an or

(Start Time < 07:00 or Start Time > 15:30)

Ian

 

[puddinpop]

Thanks very much for the quick reply Ian! I will give that a try.