Between Dates on Access doesnt work right

ok - i would post in my old thread but it says in the rules "dont bring up old threads" so my old thread is on page 3

*start edit* sorry forgot to add the link in: http://forums.webwiz.net/forum_posts.asp?TID=1426&PN=3 *end edit*

and i was wondering why i get this error:

error '80020009'

Exception occurred.

/calls-report-results.asp, line 51

it only happens on certen dates like if i do between"10/03/2003" and "10/04/2003"

but if i change the first one to a diff date it will work - or sum dont

its kinda annoyin - anyone know how to fix it?

sql = "SELECT * FROM Calls WHERE CallDate BETWEEN #" & DateFrom & "# AND #" & DateTo & "# ORDER BY CallDate DESC, CallTime DESC"

umm there ya go - thats my code

it sum times works, but sumtimes doesnt
could it be beocse sumtimes i dont have that date in my database?

it's because access store the dates in US format, no matter what version you have... my brazilian version do this too...

you have two options, store the dates in a different format (I don't remeber the name of this...)

or... a little workaround I use in my site:

Before the query:

LCID=1033 (us LCID)

and before you start to writte your html (and after the query) put

LCID=yourLCIDcode

this way the code and access will understand the same date and you will still keep yuor country format for the visitors