Hi,

I have some database tables I need to get date out of but the date format is odd. Date is stored in integers, but its not unix time. I assume that biggest number in table is for today and the max value is 77879. Any one have idea how to get this to normal date format like '2014-03-20' for today.

Thanks.

number of days since 1800-12-28

probably supposed to be number of days since 1801-01-01 and some discrepancy from leap centuries or something. Play with dates in that range and maybe you can get something that works.

You are correct. With this statement "DateAdd(day, @Date- 4, '1801-01-01')" we seem to get correct dates. Thanks.

Another column holds time, it is in odd format aswell. Example value is 4515118 and that should be somewhere close to mid day I suppose. Any ideas on that?

hundreths of a second since midnight? High noon would be 4320000

Correct. I tried that before but it didn't work so I thought it cant be that. Had to convert ms to second before using database conversion to make it work. Thanks again.