print db(db.t.day<datetime.date(2007,12,4)).select(db.t.day.max()).first() [db.t.day.max()]
On Feb 15, 4:49 pm, baloan <balo...@googlemail.com> wrote: > Now I'm trying to do > > SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' > > and I fail to find an operator for "MAX" in the web2py book. Is it > supported? > > Regards, Andreas > > PS: The online book is splendid. I like it. Much easier to work with. > Now web2py is a truly "free" application. > > Note: In section 6.5 the paragraph on "Logical Operators" has some > typos at the operators (&~). -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.