Hi,

I am doing a project in VB and MS Access. I have designed one crystal report which fethc data from one table. Now I want to select the records only between some dates (this date is one field in the table). In the VB code i wrote code like this

cryst.selectionformula = "{tablename.date} >= '1/1/2003' and {tablename.date} <= '10/10/20003' "

but it is not coming, giving error message like "Error in formula".
Is my selectionformula is correct or not, can we compare dates by enclosing between single quotes('). Please any one can help me.

Thanks in advance.

sunil.