| View previous topic :: View next topic |
| Author |
Message |
John Scott
Guest
|
 Posted: Fri Jan 23, 2004 5:44 pm Post subject: Using Dates in Access 2K |
 |
|
Help. my application worked correctly when using Access 97 with the
BDE. The query used was:
select * from tblAppointments
where AppointmentDate=#02/02/2004#
order by AppointmentTime
But when I switched to Access 2000 using an ODBC alias I got the
error:
Invalid use of keyword
Token #02/02/2004#
How should I make a query with a litteral date value?
John
|
|
| Back to top |
|
 |
Thomas L. Goodson
Guest
|
| Posted: Sun Jan 25, 2004 7:24 pm Post subject: Re: Using Dates in Access 2K |
|
|
Try using ' instead of # i.e.
where AppointmentDate='02/02/2004'
** Tom **
"John Scott" <jscott (AT) kw (DOT) igs.net> wrote
| Quote: | Help. my application worked correctly when using Access 97 with the
BDE. The query used was:
select * from tblAppointments
where AppointmentDate=#02/02/2004#
order by AppointmentTime
But when I switched to Access 2000 using an ODBC alias I got the
error:
Invalid use of keyword
Token #02/02/2004#
How should I make a query with a litteral date value?
John
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
