topic Date from excel in QV in QlikView

Date from excel in QV

francisvandergr — Fri, 25 Nov 2011 15:41:56 GMT

I hav ea file with a column Date. When i read this date into QV i get no date but a value. I attached the Qv file and the Excel file. Can someone help me ?Is transpose the problem ?

Date from excel in QV

p_verkooijen — Fri, 25 Nov 2011 16:03:21 GMT

This would work, QV changes date content to a numeric value.

HoursTable:
LOAD
Debnr,
Ordernr,
DATE(SUBFIELD(Datum, '.', 1)) AS Datum,
Uren,
[.] AS Onbekend
RESIDENT Hours;

DROP TABLE Hours;