Using SAS to read the 'Create Date' in the DTOC4SYS object

Products

• Vantage Storage Resource Manager

Issue/Introduction

I'm trying to use SAS (or Sort) to build a report from a DTOC4SYS Capture file.
The 'Create Date' isn't giving me anything recognizable, and today's date appears as '7600F1'.
 

Environment

Vantage

Resolution

The way that the date is parsed is:

The first two characters is the year which is added to d'1900'.
So, x'76' = d'118' which gives you 2018. Then, x'00F1 = d'241', then your trusty Julian calendar shows that as Aug 29. 
So, that is how Vantage stores the date in as compact a format as possible, and also be compatible for year 2000 and beyond.