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!

Reply via email to