date problems

P

polilop

i have a table with a short date fiel(dd.mm.yyyy)
i made a query to get data from a date.
When i put in my query design view that the date has to be equal to
#3.8.2005#
when i look into the sql view it writes
#8/3/2005#

It's a problem becouse it dosent give me the right data.
I'm from croatia so it maybe a locale problem but don't know how to solve
it?????
 
F

fredg

i have a table with a short date fiel(dd.mm.yyyy)
i made a query to get data from a date.
When i put in my query design view that the date has to be equal to
#3.8.2005#
when i look into the sql view it writes
#8/3/2005#

It's a problem becouse it dosent give me the right data.
I'm from croatia so it maybe a locale problem but don't know how to solve
it?????
Click to expand...

3.8.2005 is an ambiguous date in Access.
It can mean March 8, or August 3.
You MUST use the American style of date entry in a query SQL,
mm/dd/yyyy, so August 8, 2005 must be written as #8/3/2005#
This has no effect on how the field is actually formatted. It will
still display as dd.mm.yyyy if that is your regional format setting.
 
P

polilop

That did it, just set the locale to US thx
fredg said:
3.8.2005 is an ambiguous date in Access.
It can mean March 8, or August 3.
You MUST use the American style of date entry in a query SQL,
mm/dd/yyyy, so August 8, 2005 must be written as #8/3/2005#
This has no effect on how the field is actually formatted. It will
still display as dd.mm.yyyy if that is your regional format setting.
Click to expand...
 
Top