SQL statement with date/time problem

[jakeisstoked]

Hi,
This probably has a simple answer but I've never doe it before so I'm stuck.

Heres my SQL statement

&quot;SELECT * FROM tblExample WHERE pDate >'01/01/01' AND pDateSubmitted <'10/05/10'&quot;

Using this statement gets a data type mismath error.

And

&quot;SELECT * FROM tblExample WHERE pDate >01/01/01 AND pDateSubmitted <10/05/10&quot;

Never returns any records, it's a date/time field in the database, I've tried a lot of combinations and I've got no idea.

Any help would be great.

Jake

 

[shaddow]

Are you using Access Databse?

________
George, M

 

[jakeisstoked]

Yes, Access. By the way, both pDateSubmitted should be pDate, thats a typo, not a problem in my SQL.

 

[shaddow]

Ah then if you are using OLEDB connection you should use this way
&quot;SELECT * FROM tblExample WHERE pDate BETWEEN #01/01/01# AND #10/05/10#&quot;




________
George, M

 

[jakeisstoked]

Thanks alot, solved my problem! Is it only date/time that has to be ecnased inside 3's?

 

[jakeisstoked]

inside #'s that should be...