I would think that the hard coded date is the way I'd do that. maybe not neccessarily a start_dt, but maybe a pay_pd_st date. This date is just the date the payperiod falls on. You increment it once every two weeks. Have a table in your db with that field and variable. maybe hardcode the very first date. and a pay period date. if on linux or unix you can run a cron job to increment that date, or do some calculation to the hardcoded date when displaying a calendar. hmm... i'm rambling.. -----Original Message----- From: Darren Bentley [mailto:darren@bcgroup.net] Sent: Tuesday, November 12, 2002 1:51 PM To: php-db@lists.php.net Subject: payperiods Hello, I have build a php calendar and want to implement 2 week payperiods so staff can enter their hours worked. Then I can summarize work done per pay period. Any idea what the easiest way to do this is? I could hard code a starting date into a database, then go up 2 weeks at a time from there. Is there a better way? Thanks, -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
