[web2py] Re: Datetime Grid Filtering ignores localized format and timezone

nope! the issue is that SQLFORM.build_query can't understand localized dates. On Tuesday, December 23, 2014 8:35:28 AM UTC+1, Paolo Valleri wrote: > > Hi, > the issue is here > https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L1830 > can you try to replace that line with the followi

[web2py] Re: Datetime Grid Filtering ignores localized format and timezone

Hello, Sounded promising, but fails. Changed web2py/gluon/sqlhtml.py with v2.9.11 and with trunk version. Even fails if a use literal translated string as in: iso_format = {'_data-w2p_datetime_format' : '%d/%m/%Y %H:%M:%S'} Code to reproduce: def dt(): from datetime import datetime T.f

[web2py] Re: Datetime Grid Filtering ignores localized format and timezone

Hi, the issue is here https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L1830 can you try to replace that line with the following: iso_format = {'_data-w2p_datetime_format' : T('%Y-%m-%d %H:%M:%S')} Paolo On Monday, December 22, 2014 11:02:00 PM UTC+1, mcamel wrote: > > Hi all, > > I