how to retrive "date" from
access database whichs format is like(mm/dd/yyyy), using SQL command in
ASP?? have any answer???
I M MAKIN SEARCH PAGE USING ASP WHERE I HAVE PUTTED AN OPTION DATE SEARCH... I HAVE COMBO BOX FOR DAY MONTH,AND YEAR AND WHEN IT SUBMITS I HAVE USED ON NEXT PAGE

day=request("day")
month=request("month")
year=request("year")
date=month & "/" & day & "/" & year


QUERY= select * table where date=" & date

SEARCH SHOWS ZERO RESULTS...
I HAVE RECORDS IN THE TABLE BUT STILL...

pls reply back
me at [email protected]


sandesh

Hi
use QUERY= "select * from table where date=#" & date & "#" instead.


Regards
Raj