Closed GoogleCodeExporter closed 8 years ago
Hi 128625, thanks for pointing out the exact line for me.
$utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY - 86400);
works better for me though. I'd love to see this issue fixed, my need for this
function is to import dates of the format m/d/yyyy hh:mm:ss AM/PM and your work-
around has saved the day for me - will use this until a permanent fix comes by.
Original comment by karthikp...@gmail.com
on 24 Jan 2009 at 9:42
I believe I have made a fix for the date issues and will be checking it in
shortly
Original comment by matthew....@gmail.com
on 26 Jan 2009 at 5:56
I believe the issue with dates being off has been fixed.
Original comment by matthew....@gmail.com
on 26 Jan 2009 at 6:16
Please submit this bug to the downloable file, cos the last modification still
has
the problem.
thanks
Original comment by maoneid
on 18 Feb 2009 at 4:43
I have problems with Date.
In the cell I have '03-12-2003', but val function retreives
2003200320032003/DecDec/MonMon
Original comment by sebasala...@gmail.com
on 17 Apr 2009 at 8:19
Please submit an XLS file showing the problem if you think it still exists.
Also, let
us know your time zone and what your default date format is (mm/dd/yyyy or
dd/mm/yyyy)
Original comment by matthew....@gmail.com
on 17 Apr 2009 at 10:33
Hai
I have problem with date format.my excel date method is (12/09/2011) dd/mm/yyyy
. while reading the excel date column date is converted to
MonMon/SepSep/2011201120112011 .
so now how to convert the proper date method?
thanks,
Original comment by maniprak...@gmail.com
on 22 Sep 2011 at 5:48
Hai
I have problem with date format.my excel date method is (12/09/2011) dd/mm/yyyy
. while reading the excel date column date is converted to
MonMon/SepSep/2011201120112011 .
so now how to convert the proper date method?
thanks,
Original comment by maniprak...@gmail.com
on 22 Sep 2011 at 6:14
Original issue reported on code.google.com by
128625
on 17 Dec 2008 at 12:03