Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
I had the same problem and Pacos answer has fixed it nicely. thanks
John, You're my Hero