Hi Here i tried a lot. there is a problem in date format. While am retrieving date from access to jsp. format is changed 2009-03-11 00:00:00 like this. I cant select and between queries in jsp. it shows wrong data. How to get date only from access. Get two date start date and end date. Apply that in select * from tablename where programdate between startdate and enddate. but i cant retrieve that output exactly. Thanks in Advance kglnsify