Hi all, I have a Crystal report. I am trying to filter it by date range and status. The text below does run when put in the selection formula but does nothing, just shows all the data. I guess the syntax must be wrong but there isn't much Crystal help I can see in VS2005;
{jobs.status} = '5' AND {jobs.enquirydate}>= date(2010,01,01) AND
{jobs.enquirydate}<= date(2011,02,01)
Thanks
