Our software can read and create QVD files, We spend a lot of time making sure that it works as expected.

The Problem

But there is a problem: reading date fields. Our software assumes that if there is tag $date or $timestamp it is a date field. However quite often this assumption is wrong.  It is just telling us that it is possible to represent the data as date value and it does not necessarily mean that it is actually a date field.


How DateTime data is stored

Datetime fields are stored as a number, 12/01/2015 and 12-01-2015 look different but internal numeric representation is the same

Numeric representation of date field

The Solution

In the latest release of Advanced ETL Processor, we added a new option "Ignore Format". When selected data is always interpreted as a number.

Ignore Format Option

Direct link, no registration required.