Date is encoded. Can't figure it out.

99 Views Asked by At

I have dates that are encoded in a MSSQL db but we need to crack the date encoding to build some software that can plug-in to the db(which belongs to us).

01/20/2011 = 76724

03/08/2011 = 76771

10/11/2011 = 76988

11/10/2011 = 77018

Any ideas on the encoding being used?

1

There are 1 best solutions below

1
On BEST ANSWER

It seems to be the number of days since 28 December 1800.

Calculations checked with http://www.timeanddate.com/date/dateadd.html.