Hi web2py; I've got some problems. I'm attempting to get a count of some rows based on the date; but when I attempt the grouping, it includes the time as well, giving me a false count. (Since no two rows were created at the exact same second, the count never goes above 1 per 'date')
Here's my current code: count = db.posts.id.count() set = db(db.posts.id).select(db.posts.posted_date, count, groupby=db.posts.posted_date) How can I change the groupby to ignore the time portion of the posted_date?
