Use strtotime() instead.. http://us2.php.net/manual/en/function.strtotime.php Regards, Neal Carmine Nine Systems Corporation -----Original Message----- From: Karen Resplendo [mailto:karenresplendo@xxxxxxxxx] Sent: Friday, July 02, 2004 12:36 PM To: php-db@xxxxxxxxxxxxx Subject: Date problem: data is current as of yesterday 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>"; --------------------------------- 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
