Yes I have it in my it.py language file.
But when I choose in the datepicker a date in my Italian page, date picker
give me the date in '%d/%m/%Y', but the field validation still in US format:
enter date as 1963-08-28
Here is my field in db.py:
Field('concert_date', type='date', requires = IS_DATE(format=T('%Y-%m-%d')))
Perhaps I have to do something more in my grid ?
def edit_concerts():
query = db.concerts
grid = SQLFORM.grid(query=query, csv=False, links_in_grid=False, links=
None, searchable=True, editable=True, deletable=False, create=True, details=
True, orderby=db.concerts.concert_date)
return dict(grid = grid)
Thanks.
Il giorno lunedì 3 marzo 2014 13:25:33 UTC+1, mcamel ha scritto:
>
> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
