Date from excel in QV

[francisvandergr]

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 ?

[p_verkooijen · Accepted solution]

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;