Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

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

open
nobody
None
7
2008-07-19
2008-07-18
Sakthikumar B
No

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.

Discussion

  • Sakthikumar B
    Sakthikumar B
    2008-07-19

    • priority: 5 --> 7
     
  • 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