Filtering a Crystal Report by date using the SelectionFormula

[Markei54545]

HI all,

I am using VB.net 2005 to display a Crystal report. It displays OK
using report viewer but when I apply the selection formula it doesn't
have any affect (just displays all records)


{jobs.status} = '5' AND {jobs.enquirydate}>= date(2010,01,01) AND
{jobs.enquirydate}<= date(2011,02,01)

I guess it is the syntax but any ideas?

Cheers