Ecel upload and crosstable --Date format as text

[EAK]

Hi

I uploaded attached excel file including dates.

While uploding I  am using crosstable function in order to get tranpose value.(everything is ok )

However the date format occurs as text. I tried many functions (date, date#, date(date#), floor etc)

But I couldnt change the format. (pls see attached file)

Is it due to the crosstable function?

Is there any way to change the format text to date?

Thanks a lot.

[marcus_sommer]

Try it with: date(num#(YourDateField))

- Marcus

[MarcoWedel]

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083#:~:text=The%20numeri...