PHP Classes

UK date issue

Recommend this page to a friend!

      SimpleXLSX  >  All threads  >  UK date issue  >  (Un) Subscribe thread alerts  
Subject:UK date issue
Summary:Issue in UK Date
Messages:2
Author:eshban
Date:2014-10-12 19:33:06
 

  1. UK date issue   Reply   Report abuse  
Picture of eshban eshban - 2014-10-12 19:33:06
Hi, I trying to make this script work for me. That date is proving a problem. At first glance I thought it was a Unix timestamp for example 29/03/2008 (uk dates dd/mm/yyyy) comes out as 39536 (which isn’t a unix timestamp on closer look). There is consistency 02/06/2008 is 39601 and 08/06/2008 is 08/06/2008 is 39607. Without getting into finding the date that these numbers start from and doing the math every time. Sure I could work that out with some effort, but have you a simpler solution. I am sure it works with US spreadsheets.

Looking forward for your reply

  2. Re: UK date issue   Reply   Report abuse  
Picture of Sergey Shuchkin Sergey Shuchkin - 2014-10-12 20:14:26 - In reply to message 1 from eshban
see $xlsx->unixstamp( $excel_stamp )

* line 569 in class source