Import dates from Excel

[#1]

Hi ,

I'm working on a file based on a BO extraction where i got 2 fields as date.

Unfortunately when the files are loaded i got values in this way 40817,12354 which is the xls date format, how could I transform them into DD/MM/YYYY?

Thanks in advance

Bruno

[kamalqlik]

DATE("Your field",'DD/MM'YYYY') AS "Field Name"

and if you are getting duplicate value...than you can use the dual()

[#3]

Hi, as attachment the report i'm working on...

[#4]

I solve this issue....now I'm working on the traffic light indcator....i would set the indicator on this expression:

count (num att) if codice esito= ok / count (num att)