I am trying to find out if a certain date falls between two dates. I am using the sql "BETWEEN" statement. However the query is not working. Do I have to store the date I take from the database and the dates inputted in special strings? I am using mySQL and ASP. mySQL date format is yyyy-mm-dd