Our payperiods will always be 2 week increments. So if I specify a starting day in the database I need to have that starting day always updated to the current starting day. (when we switch to the new payperiod), so as Jerrad mentioned I could use a cron job. But how would I be able to look at past payperiods? Lets say I want to view a payperiod from September, then this method won't work. I'm trying to automate this so employees don't have to specify dates. They just click the date on the calendar and enter their hours worked per task. Then the accountants can go to a "summaries" page where they can click on the staff member and view any current and past pay periods. This sounded easy when I first started :) Thanks again for the help! -- Darren Bentley / Systems Administrator Borealis Internet / 1-800-667-0307 Prince George, BC, Canada http://www.pgweb.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php