Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Giving Wrong Date

Help
dipali
2012-12-18
2013-05-02
  • dipali
    dipali
    2012-12-18

    I am importing the .xls files. In that .xls file there is one field with date format in mm/dd/yyyy. But when i run the script i am getting wrong date as decdec/tuetue/20122012. i want the output as 10/12/2012. I have tried all the solutions given in this forum related to date problem. But its not working still. So please give me solution on this?

     

  • Anonymous
    2013-03-15

    1 - Look for $isdate = TRUE; in reader.php file
    2 - Add these 3 lines after that line:

                                        $formatstr = str_replace('DD', 'd', $formatstr);
                                        $formatstr = str_replace('MM', 'm', $formatstr);
                                        $formatstr = str_replace('YYYY', 'Y', $formatstr);

    That's all