Ok so i am making a program in visual basic express 2010, and i have it hooked upto a database made in access 2007.

I run a query on the database like "SELECT * FROM myTable WHERE myDate=#08/10/2010#"

this should work fine as i have checked my database and the dates in their afre in nz date format and their are three rows in the database with this date but my query returns nothing.

So i thought i would change my query to use american dates, so my query is now like this:

"SELECT * FROM myTable WHERE myDate=#10/08/2010#"

and for some strange reason this works even though it shouldn't.

Anyway i thought sweet i will just use american dates and it will be fine - turns out i was wrong, as soon as the date goes over the 12th day it error so when the query is like this:


"SELECT * FROM myTable WHERE myDate=#10/13/2010#"

it has an overloaded date error in visual basic.

I have no idea what i have done wrong here but any help would be fantastic as this has been frustrating me for days.

Cheers