I changed the web2py ajax.html date format and also used the IS_DATE constraint to get the date in dd-mm-yyyy format. When I submit the data via sqlform, everything is ok.but When I added an extra date element in the sqlform and tried to insert it in a table using db.mytable.insert(mydate=form.vars.date1), the form gets submitted.But when I try to view the table data via admin interface or sqlform.grid, I get ticket showing :
'day is out of range for month' .