I have the following Where Clause. I am getting date ranges that fall outside of my dates. I'm not sure how to format this so that I only get date ranges between the entered dates.
WHERE [Disposition Date] BETWEEN '08/01/2010'
AND CSC.DispositionCode IN ( '4', '5', '6', '11', '12', '13', '14',
'15', '18' )
OR ( CSC.DispositionCode = '3'
AND [Indem Paid] >= '0.00'
OR ( CSC.DispositionCode = 'E'
AND AppealFlag = 'Y'