Convert general excel to normal datetime

[Jogi]

      36464 => 1/11/1999
      37104 => 1/08/2001
      35412 => 13/12/1996

I need to do this transformation in qlikview. How can this be achieved?

[StarinieriG]

Hi,

have you tried with

date(field)?

[Kashyap_R · Accepted solution]

Hi

try this   Date(Date field,'DD/MM/YYYY')

Thanks