accidentally replied only to karen.
> The database queries all the sources at night after everyone has gone home. That means the data was current as of yesterday. This little snippet below returns yesterday's date, except that the first day of the month returns "0" for > the day. Now, I know why this is happening, but I can't find out how to fix it (in VBA or SQL Server I would just > say, "date()-1": > $today = getdate(); > $month = $today['month'] ; > $mday = $today['mday'] -1; > $year = $today['year']; > echo "Data is current as of <b>$month $mday, $year</b><br>"; ____________________ you can do the same thing with php. I'd use a timestamp and subtract 86400 (24 hours of seconds) $yesterday_at_this_time = date("Y-m-d H:i:s", time() - 86400); hth Jeff --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php