Date problem

[#1]

I'm loading data from a QVD. There is a date contained in my dataset; however, I can only reading it using the Date#() function. Attempts to load or subsequently convert the numeric date to a proper date 'M/D/YYYY' format do not work. I've tried everything I can think of:

Date#(myDate) - populates ok, but I really need to read using Date() so I can compare with other fields
Date(myDate) - doesn't work. No values populated
Date(Date#(myDate)) - doesn't work. No values populated
Date(Num(myDate)) - doesn't work. No values populated
Date(Date#(Num(myDate,'000000'),'YYMMDD')) - doesn't work. No values populated

I'm out of ideas. Can anyone help? I have no idea why I can't read in a simple date. Also, is there a way to look at the decimal value of what is actually stored in the column?

[#2]

You must evaluate your date:

Map_Extradata:

Directory;

CrossTable(YourDate, Data,3)

LOAD * FROM

[\\telesto\Base para QV\Balance & Cta. Resultados\Datos adicionales resultados.xlsx]

(ooxml, embedded labels, table is Plano);

LOAD

Fila,

Concepto,

Empresa,

Date(Num(Evaluate(YourDate) )) as "Posting Date",

Datos as Amount

Resident Map_Extrasata;

Drop Table Map_Extradata;

[charlotte_qvw]

I had the same problem and Pacos answer has fixed it nicely. thanks

[thierrytt1102]

John, You're my Hero