CR 10.2 - Is this correct syntax?

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

Code:

---

{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,

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'

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.