Thanks man.  That worked!

Thanks man! That worked.

Another question though. Since I am now defaulting the start / end parms to the beginning and end of month, I'd like to make both...

I got it working. I had to strip out the old column names from my old query in my report. It works now.

Well, this code works:

WHERE (surgeries.sur_or_start_datetime BETWEEN CONVERT(datetime, @StartDate, 120) AND CONVERT(datetime, @EndDate, 120) + 1) AND

...

My report works correctly if I comment out the WHERE code starting at the first OR. Actually it works fine if I leave in any of the blocks of...

Sorry, I probably posted this in the wrong forum.

Thanks for the reply. Sorry, but I forgot to mention something about that. I tried enclosing the code in parenthese (). But if I run the SQL...