Tell web2py that those fields are supposed to be dates and it'll take care
of the date format for you.
Here's a form I use for finding stats between two dates, should be easy
enough to modify for your purposes
form = FORM(TABLE(TR(TD("First Date:"),
TD(
INPUT(_type="text",
_name="start_date",
_id="start_date",
_class='date',
_value=start_date,
requires=[IS_DATE(error_message="Invalid Date
Entered")]))),
TR(
TD("Second Date:"),
TD(INPUT(_type="text",
_name="end_date",
_id="end_date",
_class='date',
_value=end_date,
requires=[IS_DATE(error_message="Invalid Date
Entered")]))),
TR(INPUT(_type="submit", _value="Get Stats"))))
Then when you validate the form, your dates will be converted to python date
objects for you & your query should work.
if form.accepts(request.vars, session, keepvalues=True):
start_date = form.vars.start_date
end_date = form.vars.end_date
