the dal has no weekday function but datetime.date does. That means if you select the records by some time range we you can maniputale them at the Python/web2py level. How really depends on details. You could also create a function that uses datetime weekday to build query ranges for dal.
On May 13, 11:10 am, greenpoise <danel.sega...@gmail.com> wrote: > Is there such thing? i need to group a result set by weeks. Sort of > like total sales of the week. How could I accomplish this? I really > dont want the user to be entering a range of dates. The weeks will > always start on Monday and finish on Sunday. My table takes daily > sales. > > Thanks