date in 1900

[Anon]

I'm exporting dates from timeslips and one of the values is the number of days since January 1, 1900. which means the values are around like 37000. I want to get the day you are looking at by doing something like this:

mktime(0,0,0,1,(1+$num_days_since),1900));

where $num_days_since is the days since 1,1,1900

im sure this is having issues because its trying to create a time before some sorta epoch, but whadda you think?

[Anon]

let's assume $days_1900 is your varibale with the # of days since 01-01-1900.

<?
$days_1900 = 37000;

$days_1970 = $days_1900 - 25550;
$timestamp = $days_1970 24 60 * 60;

$date = date ('m-d-Y', $timestamp);
?>

[Anon]

Yeah, that was the only way i could think to get around it.