Date issue in qlik sense

[rathnam_qv]

Hi All,

i am pulling date field from Teradata to Qlik sense.

But few records are coming in number format and few are coming as normal Date format.

PFA image.

I tried to convert it to Date Still it is giving the same results.

Can anybody suggest me on this.

Thanks,

Rathnam.

[Chanty4u]

try like below and see

date(yourfield,'DD/MM/YYYY') as MyDate