Can you show your exact web2py_ajax.html and IS_DATE() code? On Wednesday, June 20, 2012 3:12:15 PM UTC-4, rahulserver wrote: > > 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' . > > >
--