From: Alan Knowles Date: Mon, 27 Mar 2017 03:17:14 +0000 (+0800) Subject: SimpleExcel.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=cc243c14b6c7f5ada0bf7b837aa58070530e7fbd SimpleExcel.php --- diff --git a/SimpleExcel.php b/SimpleExcel.php index 18bce6fe..bea9c93a 100644 --- a/SimpleExcel.php +++ b/SimpleExcel.php @@ -386,8 +386,11 @@ class Pman_Core_SimpleExcel extends Pman $dataFormat = 'date'; $format = empty($format) ? $this->formats['_default_date_format_']: $format; $ut_to_ed_diff = 86400 * 25569; + $gmt = strtotime('1970-01-01'); - $v = (strtotime($v) + $ut_to_ed_diff) / 86400; + $v = (strtotime($v) + $ut_to_ed_diff - $gmt) / 86400; + // need to +8hrs to get real time.. + }