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.