the IS_DATE and IS_DATETIME accept a format argument. You should set it explicitly
db.table.field.requires=IS_DATE(format=T('%Y-%M-%D')) then use the translation interface to translate both the string above and the calendar.js translation string. Massimo On Dec 23, 8:24 pm, Brian M <bmere...@gmail.com> wrote: > Mengu's right. While changing the format in web2py_ajax would make the > chosen date display in the format you wanted, upon submission the form > will be rejected because web2py wants only yyyy-mm-dd format. So if > you go that route you'd have to do some form processing yourself to > convert formats and probably not use SQLFORM. > > Perhaps you could add an extra field that would be updated every time > the chosen date changed and have that field be in the correct format? > I know that jQuery UI's datepicker has an altField option built-in, > but I don't think the DynarchCalendar that web2py uses does. Maybe you > could create a widget that would use the jQuery UI calendar instead? > > ~Brian > > On Dec 23, 6:54 pm, Mengu <whalb...@gmail.com> wrote: > > > And note that yyyy-mm-dd format is the way how mysql and sqlite keep > > dates. > > > On Dec 23, 4:39 pm, Brian M <bmere...@gmail.com> wrote: > > > > I think that the format is controlled in the web2py_ajax.html view. > > > > try {jQuery("input.date").focus( function() {Calendar.setup({ > > > inputField:this.id, ifFormat:"{{=T('%Y-%m-%d')}}", > > > showsTime:false > > > }); }); } catch(e) {}; > > > try { jQuery("input.datetime").focus( function() {Calendar.setup({ > > > inputField:this.id, ifFormat:"{{=T('%Y-%m-%d %H:%M:%S')}}", > > > showsTime: true,timeFormat: "24" > > > }); }); } catch(e) {}; > > > > Since the format string seems to be in a T() I would guess that it's > > > possible to change that using translations? > > > > ~Brian > > > > On Dec 23, 7:29 am, Alexandre Andrade <alexandrema...@gmail.com> > > > wrote: > > > > > While > > > > > db.convenio.data_assinatura.requires = > > > > IS_DATE(format=T('%d-%m-%Y'),error_message=T('deve ser no formato > > > > DD-MM-AAAA!')) > > > > > show me the date in correct locale, the calendar widget don't show the > > > > correct date. > > > > > How to locale it or make it show the correct date? > > > > > -- > > > > Atenciosamente > > > > > -- > > > > ========================= > > > > Alexandre Andrade > > > > Hipercenter.com > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.