PDA

Click to See Complete Forum and Search --> : Crystal Reports 10.2 Is the Between Operator valid?

blakemckenna
May 24th, 2007, 05:26 PM
Is this a valid statement for Crystal Reports 10.2???


({tblTimeSheetDetail.monDate} BETWEEN '5/7/2007' AND '5/20/2007' AND {tblTimeSheetDetail.sunDate} = '5/20/2007') AND {tblTimeSheetDetail.project} > ''
brucevde
May 24th, 2007, 05:34 PM
No.

Crystal has several Range functions. The syntax of a range that includes the end points is

{FieldName} In X To Y
blakemckenna
May 24th, 2007, 05:42 PM
So would this be correct?


({tblTimeSheetDetail.monDate} IN '5/7/2007' TO '5/20/2007' AND {tblTimeSheetDetail.sunDate