Our software can read and create QVD files, We spend a lot of time making sure that it works as expected.
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
In the latest release of Advanced ETL Processor, we added a new option "Ignore Format". When selected data is always interpreted as a number.