Iso format like: day_and_time >= "2000-01-01 00:00:00" Must be ISO and UTC regardless you are using (and seeing) localized format and/or timezone (at least just now). Related question: https://groups.google.com/forum/?fromgroups=#!topic/web2py/fDP4mrIFdXg
Regards. El martes, 20 de mayo de 2014 00:08:32 UTC+2, Manuele escribió: > > Hi, > can somebody help me to build up smart queries that involve datetime > fields? > How format I have to use for the datetime I want use as comparison value? > > than you very mutch > cheers > > Manuele > -- 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/d/optout.