sql error when day part of date starts with a zero

[OceanaPolynom]

Hello
I am using VB 6 to program a Access 2003 type database file. This is the code that creates the sql expression

ssql = "select * from tblraw where (tblraw.rawdate=#" & thisdate & "#) and (tblraw.rawcn=" & Trim(Str(thiscow&)) & ") order by tblraw.rawdate,tblraw.rawtime"

Typically the sql string looks like this :

select * from tblraw where (tblraw.rawdate=#10/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime

the above statement returns 12 records, which is correct

however if the string looks like this :
select * from tblraw where (tblraw.rawdate=#09/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime
or this :
select * from tblraw where (tblraw.rawdate=#9/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime

then zero records are returned, although they exist in the database file. I find this most unfair.



Thank you for any help in advance

John

[June7]

Field rawdate is a date/time type? Query should work.

Is the criteria MM/DD/YYYY?

[OceanaPolynom]

Hello
rawdate is defined as date/time field
basic Date command returns dd/mm/yyy
the Access date fields are dd/mm/yyyy with leading zeros

the query only seems to work with dates that have no leading zeros

a date like 09/10/2012 returns no records

Thanks

[June7]

Regarding international date structure and Access date storage, review http://allenbrowne.com/ser-36.html

[OceanaPolynom]

Hello
By using Function SQLDate found on Allen Browne s page, the problem was solved immediately
Many thanks