I have two textfields which are formatted for dates, i want to retrieve data from the database within a period of days which the two textfields stand for the "from" and "to" dates.Can anybody help me out?

select distinct courseId,courseName,description,Date,amount from course where date>='2013/05/11' and date<='2013/05/11'
for the SQL queries above, i used JDatepickers, the Jdatefield when editted to pick to pick the date, it does not change, when i echo the combination of the sql query, it shows current date.

so ... what exactly did you expect? if the current (now yesterdays) date is in your db, that result is correct.