Is this a valid statement for Crystal Reports 10.2???
Code:({tblTimeSheetDetail.monDate} BETWEEN '5/7/2007' AND '5/20/2007' AND {tblTimeSheetDetail.sunDate} = '5/20/2007') AND {tblTimeSheetDetail.project} > ''
Printable View
Is this a valid statement for Crystal Reports 10.2???
Code:({tblTimeSheetDetail.monDate} BETWEEN '5/7/2007' AND '5/20/2007' AND {tblTimeSheetDetail.sunDate} = '5/20/2007') AND {tblTimeSheetDetail.project} > ''
No.
Crystal has several Range functions. The syntax of a range that includes the end points is
{FieldName} In X To Y
So would this be correct?
Code:({tblTimeSheetDetail.monDate} IN '5/7/2007' TO '5/20/2007' AND {tblTimeSheetDetail.sunDate