Use a numeric sort instead of a string sort on DNS date field
Whilst working through some of the DNS records for our network, we noticed we were seeing some records from 2015. We tried to sort the 'Date' column in ascending/descending order and found that the fields were not formatted as 'Date/Time' but rather as a text format as the timestamps were sorted in ascending order of the first 2 numbers of the date.
As an example:
Timestamp 1: 05/04/2015
Timestamp 2: 01/02/2017
Timestamp 3: 15/03/2016
Timestamp 4: 19/06/2015
When sorted in ascending order by timestamp, the DNS records SHOULD be organised in the following format:
However, they are sorted thus:
We took a look at one of our 2008 servers and found this was the case there also.