From: josep dot gorro at trendcomms dot es Operating system: WinNT PHP version: 4.3.1 PHP Bug Type: Calendar related Bug description: Wrong JulianDayCount
Description: ------------ I'm generating a function to calculate a date in Julian day count to be used in excel spreadsheet. Always I obtain a 2 days difference. Is this a bug? Reproduce code: --------------- <?php // This is the date that I would to convert $jd1 = GregorianToJD (8,28,2003); print "$jd1\n"; $gregorian1 = JDToGregorian ($jd1); print "$gregorian1\n"; // This is the initial excel's date counter $jd2 = GregorianToJD (1,1,1900); print "$jd2\n"; $gregorian2 = JDToGregorian ($jd2); print "$gregorian2\n"; // This is the REAL (not bogus) day counter $total=$jd1 - $jd2 + 2; print "Excel value: ".$total; ?> Expected result: ---------------- Without the correction ($total=$jd1 - $jd2;) the result is: 2452880 8/28/2003 2415021 1/1/1900 Real counter: 37859 Whit the correction ($total=$jd1 - $jd2 + 2;) the result is: 2452880 8/28/2003 2415021 1/1/1900 Real counter: 37861 First one isn't correct, second one is fine. -- Edit bug report at http://bugs.php.net/?id=25288&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25288&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25288&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25288&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25288&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25288&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25288&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25288&r=support Expected behavior: http://bugs.php.net/fix.php?id=25288&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25288&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25288&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25288&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25288&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25288&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25288&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25288&r=gnused