#11 Problem in Reading MM/DD/YYYY Date Format

[Sakthikumar B]

I am trying to read a Excel file with Some Dates in different formats.

I tried this in different environments with combinations of
1. Apache/Linux
2. Apache/Windows
3. IIS/Windows.

I got a successive output from first two environments, but fails in IIS/Windows Environment.

For example, If my Input is 12/1/1972 (MM/DD/YYYY), first two environments returns 01/12/1972 (I need to perform some replace here to get 12/01/1972), but in IIS/Windows environment I got totally different output as 30/11/1972.

Kindly let me know the way to handle this.

[Nobody/Anonymous]

Hi,

Can you help me to use the php file correctly. I am not getting a human readable string. See my code segment below.

Thanks,
Bk.

Code:
$myDate = $data->sheets[$sheet]['cells'][$row][$column];
print $myDate;

Output:
39962.56

Expected:
29/05/2009