@@ -401,6 +401,7 @@
);
}else{
$isdate = FALSE;
+ $formatstr = \'\';
if ($indexCode > 0){
if (isset($this->formatRecords[$indexCode]))
$formatstr = $this->formatRecords[$indexCode];
@@ -413,8 +414,10 @@
$formatstr = str_replace(\'h\', \'H\', $formatstr);
//echo "\\ndate-time $formatstr \\n";
}
+ if ($formatstr == \'i/dd/yyyy\') { // found day and time format
+ $formatstr = \'Y-m-d\';
+ }
}
-
if ($isdate){
$this->formatRecords[\'xfrecords\'][] = array(
\'type\' => \'date\',
@@ -714,7 +717,7 @@
if ($numValue > 1){
$utcDays = $numValue - ($this->nineteenFour ? Spreadsheet_Excel_Reader_utcOffsetDays1904 : Spreadsheet_Excel_Reader_utcOffsetDays);
$utcValue = round($utcDays * Spreadsheet_Excel_Reader_msInADay);
- $string = date ($this->curformat, $utcValue);
+ $string = date ($this->curformat, $utcValue + 86400);
$raw = $utcValue;
}else{
$raw = $numValue;