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.


Reply via email to