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?
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);