db(db.mydiary.Entry_Date.month() == now.month).select(db.mydiary.ALL,orderby =~db.mydiary.Entry_Date)
Notice db.mydiary.Entry_Date.month() instead of db.mydiary.Entry_Date.month because db.mydiary.Entry_Date is not a record but an object so month is a method. In retrospect we could have designed this differently. Also, you do not need db.mydiary.ALL. db(db.mydiary.Entry_Date.month() == now.month).select(orderby=~db.mydiary. Entry_Date) On Saturday, 14 February 2015 05:45:35 UTC-6, Moiz Nagpurwala wrote: > > I want to select all records for current month. > > This is what i had tried so far. > > import datetime > def index(): > now = datetime.datetime.now() > #entries = db().select(db.mydiary.ALL, orderby=~db.mydiary.Entry_Date) > #the line below does not seem to work > entries = db(db.mydiary.Entry_Date.month == now.month).select(db.mydiary. > ALL,orderby=~db.mydiary.Entry_Date) > return locals() > > > Please help. > > Thanks. > -- 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/d/optout.
