Week Function not working on Date

[debmsarkar123]

I have an excel file whose crosstable Im loading and converting the date to week but its coming blank. A snippet of the header I have pasted.  The DT field in cross table starts from column D in the excel.

The code Im using:

Temp:

CrossTable(DT, Forecast, 3)
LOAD * FROM
[Z:\QlikView Documents\upload\xyz.xlsx]
(ooxml, embedded labels, table is Sheet1);

Data:

load*,
Week(DT,'DD/MM/YYYY') as WK

Resident Temp;

drop table Temp;

I also tried converting DT column to Date data type by passing it through Date() function but then also conversion isnt happening and its returning blank column.

[albertovarela]

It seems your date is loaded as text so you need to convert it to date first, then wrap around the week function. Try:  Week(Date#(DT,'DD/MM/YYYY')) as WK