Hi. You need to define the type of the field, the IS_DATE is only a validator that will check the values before insert/update.
Use: db.define_table('users', SQLField('dob', 'date',requires=IS_DATE()), regards mmlado On Wed, Jun 3, 2009 at 4:36 PM, durga <durgaprasadmoga...@gmail.com> wrote: > > Hi, > > i have defined a date field in my table. > db.define_table('users', > SQLField('dob',requires=IS_DATE()), > > when i click on db.users in database administration. its throwing > below error. > > > Error traceback > 1.2.3.4.5.6.7.8.9.10.11.12. Traceback (most recent call last): File > "C:\Apps\web2py_src\gluon\restricted.py", line 98, in restricted > exec ccode in environment File "C:/Apps/web2py_src/applications/ > whosay/views/appadmin.html", line 112, in <module> File "C:\Apps > \web2py_src\gluon\sqlhtml.py", line 645, in __init__ r = str > (field.formatter(r)) File "C:\Apps\web2py_src\gluon\sql.py", line > 1658, in formatter value = item.formatter(value) File "C:\Apps > \web2py_src\gluon\validators.py", line 1409, in formatter return > value.strftime(str(self.format))AttributeError: 'str' object has no > attribute 'strftime' > > thanks > durga --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---