Interesting observation, when I use a Date field (comes in 'M/D//YYYY' format) from a QVD, and do e.g. Max(DateField), I get the result in the same format but if I create another table out of that QVD using Resident, and do the Max I get an integer. Even though if I try to apply Date functions in new table, still get an integer like:
Date(DateField) or Date(Date#(DateFiled, 'M/D/YYYY'), 'M/D/YYYY')
if I do Date(DateField) while loading the QVD and no Date function in second table then I get date format back but I don't want to do Date() while loading the QVD and do Date() in second table.
Looks like not a unique issue but any thoughts?
Below is not working for me:
QVD_Table:
LOAD
DateField,
Value
FROM
"...\QVD_File.qvd"(qvd);
TableFromQVD:
NoConcatenate
LOAD
//Date(DateField, 'M/D/YYYY') as DateField,
Date(Date#(DateField, 'M/D/YYYY'), 'M/D/YYYY') as DateField,
Value
Resident QVD_Table;
DROP Table QVD_Table;