Wednesday 21 December 2011

Make DNSCMD Ageing values readable

DNSCMD data gives hours since 1/1/1600 00:00 (Source:Export DNS records to Excel to read time stamps and static records) but Excel is configured with 1/1/1900 00:00, so we need to remove the extra 300 years from our aging value first.

We'll use constant 2620924 here.
(AGE: value -2620924)/24 gives us day count from 1/1/1900 00:00

So 1/1/1900 + the day count will give us the Time Stamp value in a format we can understand.


Verified example:
AGE=3580157
=((AGE-2620924)/24)+(1/1/1900)=04/06/2009 which is same as DNS console shows.

No comments:

Post a Comment