Weekly dates from database(PostgreSQL)

admin

Administrator
Staff member
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?
 
Back
Top