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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks