|
 |
access_asp thread: Date in Access
Message #1 by kavitha_baskar@h... on Wed, 8 Aug 2001 17:52:03
|
|
Hello,
I have a problem with Date in MsAccess. I have reserve_date column in
reservation table as a date(short date) datatype. I am trying to run a
query to match the date but I am not getting any records but i do have a
record in the database with the date 01/29/02.
sSQL = "SELECT * FROM reservation WHERE reserve_date = 01/29/02"
can someone please help me?
thanks
kavitha.
Message #2 by sathish kumar <sathish297@y...> on Fri, 10 Aug 2001 22:38:51 -0700 (PDT)
|
|
Hello Kavita,
I doubt the problem to be with the year part.
Type the full year like 01/29/2002 instead of
01/29/02.
By the way where are u working? Are you from india?
with regards,
sathish.
--- kavitha_baskar@h... wrote:
> Hello,
> I have a problem with Date in MsAccess. I have
> reserve_date column in
> reservation table as a date(short date) datatype. I
> am trying to run a
> query to match the date but I am not getting any
> records but i do have a
> record in the database with the date 01/29/02.
>
> sSQL = "SELECT * FROM reservation WHERE reserve_date
> = 01/29/02"
>
> can someone please help me?
>
>
> thanks
> kavitha.
>
>
|
|
|
View Cart
