I'm not sure to understand your problem, but just in case it helps: have 
you tried to use this in your language file:

'%Y-%m-%d': '%d/%m/%Y',

Default date validator will do inner convertions between both formats, so 
you'll have no problems with DAL and database backend.

Regards.


El sábado, 1 de marzo de 2014 17:49:36 UTC+1, Gael Princivalle escribió:
>
> Hello all.
>
> I'm a little bit disappointed by the date format and datepicker.
>
> First my field was like that:
>
> Field('concert_date', type='date'),
>
> On Firefox no problem. It give me automaticly the possibility to put in 
> the field the local %d/m/%Y format, and this format was accepted by the 
> DAL. When I open this row, date is ok.
>
> As Firefox 27 for Windows is incredibly slow, I'm still using Chrome from 
> this morning.
>
> With Chrome if I open again this row date it's ok but with the US format 
> %Y-%m-%d. For example 12/03/2014 change in 2014-03-12. It's the default SQL 
> Lite date format, why not.
>
> But if I open datepicker, it shows me on the calendar September 4 2017.
>
> What I want to do is:
> Choose with datepicker the date format always like %d/m/%Y.
> Saving the date in DAL as US format %Y-%m-%d
> Showing in the row the date format as local (%Y-%m-%d or %d/m/%Y)
>
> Can you help me ?
>
> Thanks, regards.
>
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to