Please explian this Bahaviour with Dates and QVD's

[#1]

I understand that QVs default date format is YYYMMDD HH:MM:ss but this behaviour with qvds still seems weird, Im after an optimised load with a date filter ?

Load from qvd with Last Where clause from below code works but isnt an optimised load, So I attempt a Load and filter using a resident load as suggusted elsewhere on the forum. but the filter doesnt work and it doesnt error either. In the QVD the createdDate is formatted differently (DD-MM-YYYY HH:MM:SS)

Load * FROM
 


 Data\Stktrn_20091012.qvd (qvd);
// Doesnt Work Where Date(CreatedDate,'YYYYMMDD') > '20091016';
// Doesnt Work Date(CreatedDate,'YYYYMMDD hh:mm:ss') > '20091016';
// Works Where Date(CreatedDate,'YYYYMMDD hh:mm:ss') > '20091016 00:00:00';
Load
 


 * resident stkTRN
where Date(CreatedDate,'YYYYMMDD hh:mm:ss') > '20091016 00:00:00';

[#2]

The default date format depends on the variables at the beginning of your application:

For example:

SET DateFormat='DD/MM/YYYY';

Rgds,

Sébastien