Solved

Microsoft Automation (Serial) Date conversion in PHP

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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
google map tracking website 5 23
php checkbox validation 5 27
php extract($_REQUEST) 5 48
mysqli_connect error on wamp but not on remote server 8 24
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…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
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.

770 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