CR 10.2 - Is this correct syntax?

[blakemckenna]

I have a Crystal Report 10.2 that' I'm running with VB.Net 2005. My formula looks like this:

{tblTimeSheetDetail.beginPeriodDate} = '4/9/2007' AND 
{tblTimeSheetDetail.beginPeriodDate} = '4/23/2007' AND 
{tblTimeSheetDetail.beginPeriodDate} = '4/16/2007' AND 
{tblTimeSheetDetail.project} = '2006SC013'

I was wondering if this is correct syntax because I'm not getting any results on my report when I SHOULD be. The beginPeriodDate column is a String Type within my Table.

Thanks,

[brucevde]

The syntax is correct however logically the statement is incorrect. Use OR (or IN) on the beginPeriodDatefields not AND.

({tblTimeSheetDetail.beginPeriodDate} = '4/9/2007' OR
{tblTimeSheetDetail.beginPeriodDate} = '4/23/2007' OR
tblTimeSheetDetail.beginPeriodDate} = '4/16/2007') AND
{tblTimeSheetDetail.project} = '2006SC013'

[blakemckenna]

Thanks Bruce...that worked. Do you know how I can pass the Date Values into my report. I'm sure you use parameters but I've never used parameters in CR before.