MS Access And Datetime SELECT/UPDATE

[Juggernath]

Hi,
I spent all morning trying to find a way to select a datetime field from a
table (I work with ASP)
My SQL is "SELECT * FROM Mytbl WHERE myDate = #2.12.2003# "
(I live in Croatia, so that's the setting for a time format I use in
MSAccess, also, I use a Short Date format to put into table only a date, not
time, the application will probably always work on local server - intranet)
So, in my table there are several fields 2.12.2003. but when I try to SELECT
them with above criteria it returns me an error.
I also tried "SELECT * FROM Mytbl WHERE myDate BETWEEN #1.12.2003# AND
#3.12.2003#" I also tried using LIKE statement, but it doesn't work.

[Lyle Fairfield]

"Juggernath " <Ja************ **@TOVANyahoo.c om> wrote in
news:bq******** **@bagan.srce.h r:

Hi,
I spent all morning trying to find a way to select a datetime field from
a table (I work with ASP)
My SQL is "SELECT * FROM Mytbl WHERE myDate = #2.12.2003# "
(I live in Croatia, so that's the setting for a time format I use in
MSAccess, also, I use a Short Date format to put into table only a date,
not time, the application will probably always work on local server -
intranet) So, in my table there are several fields 2.12.2003. but when I
try to SELECT them with above criteria it returns me an error.
I also tried "SELECT * FROM Mytbl WHERE myDate BETWEEN #1.12.2003# AND
#3.12.2003#" I also tried using LIKE statement, but it doesn't work.

Almost all programs, code and script recognize "yyyy-mm-dd".

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Juggernath]

"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.4...

"Juggernath " <Ja************ **@TOVANyahoo.c om> wrote in
news:bq******** **@bagan.srce.h r:

Hi,
I spent all morning trying to find a way to select a datetime field from
a table (I work with ASP)
My SQL is "SELECT * FROM Mytbl WHERE myDate = #2.12.2003# "
(I live in Croatia, so that's the setting for a time format I use in
MSAccess, also, I use a Short Date format to put into table only a date,
not time, the application will probably always work on local server -
intranet) So, in my table there are several fields 2.12.2003. but when I
try to SELECT them with above criteria it returns me an error.
I also tried "SELECT * FROM Mytbl WHERE myDate BETWEEN #1.12.2003# AND
#3.12.2003#" I also tried using LIKE statement, but it doesn't work.

Almost all programs, code and script recognize "yyyy-mm-dd".

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

I'm not so sure, because there are regional Settings on comp... In MSAccess
i have default value for the field now() and it enters d.mm.yyyy . Now I do
not understand Why cannot I simply Select with such criteria?