Is this binary date format visible?

Question

3/10/2008 = 1822556159

2/10/2008 = 1822523391

1/10/2008 = 1822490623

09/30/2008 = 1822392319

09/29/2008 = 1822359551

This is all the information that I currently know.

Dates increase by 32768, except when the month changes with an increment of 32768 x 2 (65536).

Has anyone seen this binary date format and how can I extract the correct date?

---

It is possible that the rest of the date is for time (hours, minutes, seconds)

Answer 1

September 30, 2008

1822392319 = 0x6c9f7fff
0x6c = 108 = 2008 (based on 1900 start date)
0x9 = 9 = September
0xf7fff - take top 5 bits = 0x1e = 30

October 1, 2008

1822490623 = 0x6ca0ffff
0x6c = 108 = 2008
0xa = 10  = October
0x0ffff  - take top 5 bits = 0x01 = 1

Does anyone guess what the remaining 15 bits are for.

EDIT: taking the top 5 bits, I mean:

day_of_month = (value >> 15) & 0x1f

Similarly:

year = (value >> 24) & 0xff + 1900
month = (value >> 20) & 0x0f

Answer 2

write it in binary format:

a = 1822556159
1101100 1010 00011 111111111111111
b = 1822523391
1101100 1010 00010 111111111111111
c = 1822490623
1101100 1010 00001 111111111111111
d = 1822392319    
1101100 1001 11110 111111111111111

1101100 108, , - (1010 1001) .

1s /.

Answer 3

: Alnitak . , ; , 15 - , , . , , .

: , , OLE/COM Windows, Double . , - . 1 100 31 9999. MSDN google OLE COM .

EDIT: #, DateTime.FromOADate. MSDN VariantTimeToSystemTime.

8- (double), 1 1753 31 2078 .

2.0 1 1900 ; 3.0 - 2 1900 ..

1 . . 2.5 1 1900 ; 3.25 6:00 A.M. 2 1900 ..

30 1899 .

, COleDateTime , 1 100, , 1 1753 .

VB ( CDbl() CDate()), # (DateTime.FromOADate/ToOADate), Java (OLEDate - , ), Delphi, Python ..

Answer 4

32768 2 ^ 15; 15 , , , , / .

Answer 5

"" , WinMobile (http://www.dotfred.net/default.htm): ( PPC): 0xab, 0xaa, 0xaa, 0xaa, 0x82,0xae, 0xe3,0x40 (10.Mai 2010) 0xab, 0xaa, 0xaa, 0xaa, 0xa2,0xae, 0xe3,0x40 (11.Mai 2010) 0x55,0x55,0x55,0x55,0x55,0x55,0x00,0x40 (01.Jan 1900) 0x55,0x55,0x55,0x55,0x55,0x55,0x08,0x40 (02.Jan 1900)

All this is based - I expect - on MS http://msdn.microsoft.com/en-us/library/aa908499%28v=MSDN.10%29.aspx .. but the model does not seem to be suitable for this.

Any help / suggestion? thanks gunther