problem selectionformula

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.

'10/10/20003' - Is this a typo in your post or your actual code? The Year 20003 would cause problems.

Sorry,

It is typing mistake.
actually it is '10/10/2003'