Excel reader class -- date format problem

[computerzworld]

Hello,
I am having one excel file with one column containing dates. I have formatted the date in YYYY-MM-DD format in order to enter it in mysql. I am using excel reader class for reading excel. When I read the column of dates it gives me some strange value like if the date is 1965-11-11 then it gives me as 24057. Please help me how can I get proper value in php? Thanks in advance.

[cretaceous]

I think Excel tries to impose its own ideas of what a field should display

have you tried writing a different format date?

something roughly like:

$xlday=date("d/m/Y",$mydate);

$sheet->write($xlrow,$m,$xlday,$format_bluebold);

I think you can also force the excel field to be in the desired format before writing to it
(maybe you need text format not number format)