Solved

Microsoft Automation (Serial) Date conversion in PHP

Posted on 2008-10-03
2
477 Views
Last Modified: 2012-05-05
I have a database listed with dates in Serial Format that were generated by Excel example 10/3/08 = 39724

I now have to display these dates on a web page. But I have no idea how to convert 39724 back to 10/3/08 in PHP. Anyone have any ideas?
0
Comment
Question by:SaltyDawg
2 Comments
 
LVL 6

Accepted Solution

by:
deresh earned 500 total points
ID: 22636768
this number represents number of days from  1. January 1900. so for example excel date 15 is translated to 15.Jan.1900 etc..



http://www.codeproject.com/KB/datetime/exceldmy.aspx

if should be trivial to rewrite this to php

0
 
LVL 1

Author Comment

by:SaltyDawg
ID: 22636926
Ok it should be pretty simple to write code for that. Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question