What calendar appears to count days since december 28, 1800?

Posted by Sander Marechal on Stack Overflow See other posts from Stack Overflow or by Sander Marechal
Published on 2010-04-09T11:48:58Z Indexed on 2010/04/09 11:53 UTC
Read the original article Hit count: 445

Filed under:

calendar

|

data

Hello,

I have been tasked to read in some data from some weird old system. The system contains many dates but they are all oddly formatted. They are integer numbers ranging from approximately 55,000 to 80,000.

I know two dates for certain:

58,112 equals February 2, 1960
61,439 equals March 16, 1969

It appears to me that those integer numbers are the number of days elapsed since December 28, 1800. But I think that's a very strange date to start a calendar on. There is probably going something on with leap years and what-not that is doing to bite me in the ass later on.

Does anyone recognise this calendar? Can anyone tell me what the proper way is to convert those integers to human readable dates?

Thanks in advance!

© Stack Overflow or respective owner

Related posts about calendar

Aggregate SharePoint Event/Items into your Calendar view using Calendar Overlay

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
One of the most common features I have seen in common use for SharePoint (prior to 2010) in Intranet environments for Team site is Calendar’s. Not only the Calendar list type, but also the ability to add a Calendar view to any list that has the desired columns to construct a Calendar – such as Start… >>> More
Zend Framework Project - Calendar: Need web calendar with events (like google calendar) for every u

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I doing multi users website (it should works for more than 100,000 users) with Zend Framework. I need to create event calendar like google calendar (If it was possible to use google calendar i will do it- please tell me). I have to do that from zero or exist some good Calendar that will work… >>> More
Java Calendar.set(Calendar.DAY_OF_WEEK, Calendar.SUNDAY), will it roll backwards, forwards or unknow

as seen on Stack Overflow - Search for 'Stack Overflow'
Suppose the following code is executed on the 22nd of August 2009 (a Saturday) Calendar c = Calendar.getInstance(); c.set(Calendar.DAY_OF_WEEK, Calendar.SUNDAY); c.get(Calendar.DAY_OF_MONTH) will return 23. I'm interested in the conditions is would return 14 (last Sunday, rather than the… >>> More
iCal and Google Calendar are synced, but invitations don't show up on Google Calendar

as seen on Super User - Search for 'Super User'
So I can view my Google Calendar from iCal. However when I get an invitation sent through Apple Mail and I click it, it adds the invite to the default iCal calendar and not my Google Calendar (i.e. going to Google Calendar or bringing it up on my iPhone doesn't show the newly-added event). How can… >>> More
Sync iPod Touch's calendar to Google Calendar

as seen on Super User - Search for 'Super User'
How can you sync your calendar of iPod Touch to Google Calendar? I have rarely internet connection at my iPod Touch. It has my calendar as "offline". I cannot share it with my friends. I would like to use "Google Calendar" in a offline mode such that I can more easily sync my calendar, every time… >>> More

Related posts about data

timetable in a jTable

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create a timetable in a jTable. For the top row it will display from monday to sunday and the left colume will display the time of the day with 2h interval e.g 1st colume (0000 - 0200), 2nd colume (0200 - 0400) .... And if i click a button the timing will change from 2h interval to 1h interval… >>> More
Reading data from an Entity Framework data model through a WCF Data Service

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This is going to be the fourth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here and the third one here . I have a post regarding ASP.Net and EntityDataSource. You… >>> More
SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

as seen on SQL Authority - Search for 'SQL Authority'
There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data.… >>> More
Modifying a HTML page to fix several "bugs" add a function to next/previous on a option dropdown

as seen on Stack Overflow - Search for 'Stack Overflow'
SOF, I've got a few problems plaguing me at the moment and am wondering if anyone could assist me with them. I'm trying to get Next Class | Previous Class to act as buttons so that when Next Class is clicked it will go to the next item in the dropdown list and for previous it would go to back one… >>> More
Shrinking TCP Window Size to 0 on Cisco ASA

as seen on Server Fault - Search for 'Server Fault'
Having an issue with any large file transfer that crosses our Cisco ASA unit come to an eventual pause. Setup Test1: Server A, FileZilla Client <- 1GBPS - Cisco ASA <- 1 GBPS - Server B, FileZilla Server TCP Window size on large transfers will drop to 0 after around 30 seconds of a large… >>> More