I have a form where users input work that they have performed. All this data gets stored in an activity table in a postgreSQL db. I have a date field in the table. What I want to do is create a page where users can view work performed by week and by month. I have no problem with the monthy reports because I can use the postgresql date_part() function.
My problem is with getting the weekly dates. First I want to create a <select> list that lists the last 5 Mondays then I want to just show the work performed from the week of the selected Monday.
I have been toying with using the date() and mkdate() functions but those seem a bit cumbersome for something like this.
Any Suggestions?
My problem is with getting the weekly dates. First I want to create a <select> list that lists the last 5 Mondays then I want to just show the work performed from the week of the selected Monday.
I have been toying with using the date() and mkdate() functions but those seem a bit cumbersome for something like this.
Any Suggestions?