Date Error

[kauserk]

Hello:

I have an access database that stores employee timings by date.
At the same time, I have a form that queries this database.
On the form I use a DTpicker to enable a user input the date for which
he/she wants data
When I execute the query below in my VB code, I get a run time error
that says
Error ===> "Datatype mismatch in criteria expression."
Query ===> cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = '" & dtpDate.Value & "'"

I don't understand why I get this error when
both, the field fldDate is of type Date/time and dtpDate.Value returns
the same. I tried setting both the DB date and the control date to
different date formats such as short date, long/general date, custom
date, but I still get the same error.
Appreciate any help on resolving this

[Svend Erik Johansen]

Hi

Try: fldDate = cvdate('" & dtpDate & "'")
instead

Svend
DK
<ka*****@gmail.com> skrev i en meddelelse
news:11**********************@g14g2000cwa.googlegr oups.com...

Hello:

I have an access database that stores employee timings by date.
At the same time, I have a form that queries this database.
On the form I use a DTpicker to enable a user input the date for which
he/she wants data
When I execute the query below in my VB code, I get a run time error
that says
Error ===> "Datatype mismatch in criteria expression."
Query ===> cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = '" & dtpDate.Value & "'"

I don't understand why I get this error when
both, the field fldDate is of type Date/time and dtpDate.Value returns
the same. I tried setting both the DB date and the control date to
different date formats such as short date, long/general date, custom
date, but I still get the same error.
Appreciate any help on resolving this

[Svend Erik Johansen]

.... ups... theres a " too much
this is how: fldDate = cvdate('" & dtpDate & "')

Sorry
Svend

"Svend Erik Johansen" <cr****@mail.dk> skrev i en meddelelse
news:42*********************@dread12.news.tele.dk. ..

Hi

Try: fldDate = cvdate('" & dtpDate & "'")
instead

Svend
DK
<ka*****@gmail.com> skrev i en meddelelse
news:11**********************@g14g2000cwa.googlegr oups.com...

Hello:

I have an access database that stores employee timings by date.
At the same time, I have a form that queries this database.
On the form I use a DTpicker to enable a user input the date for which
he/she wants data
When I execute the query below in my VB code, I get a run time error
that says
Error ===> "Datatype mismatch in criteria expression."
Query ===> cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = '" & dtpDate.Value & "'"

I don't understand why I get this error when
both, the field fldDate is of type Date/time and dtpDate.Value returns
the same. I tried setting both the DB date and the control date to
different date formats such as short date, long/general date, custom
date, but I still get the same error.
Appreciate any help on resolving this

[Max Healey]

Should be

cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = #" & dtpDate.Value & "#"

That is if you are in the USA Europe and Australia will need to do this to
ensure consistent results

cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = #" &dtpDate.month & "/" & dtpDate.day & "/" dtpDate.year & "#"

SQL Process dates in US Date Format but will not throw an error if you feed
it dd/mm/yy instead it try's to fix it for you so it 1/4/05 will give be
processed as 4 January where as 13/4/05 will be processed as 13 April go
figure !


<ka*****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hello:

I have an access database that stores employee timings by date.
At the same time, I have a form that queries this database.
On the form I use a DTpicker to enable a user input the date for which
he/she wants data
When I execute the query below in my VB code, I get a run time error
that says
Error ===> "Datatype mismatch in criteria expression."
Query ===> cmdQuery.CommandText = "SELECT * from tblTimings WHERE
fldDate = '" & dtpDate.Value & "'"

I don't understand why I get this error when
both, the field fldDate is of type Date/time and dtpDate.Value returns
the same. I tried setting both the DB date and the control date to
different date formats such as short date, long/general date, custom
date, but I still get the same error.
Appreciate any help on resolving this