Solved

Microsoft Automation (Serial) Date conversion in PHP

Posted on 2008-10-03
2
473 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
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 …
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now