topic Re: Convert general excel to normal datetime in QlikView

Convert general excel to normal datetime

Jogi — Wed, 16 Oct 2019 10:56:28 GMT

      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 — Wed, 16 Oct 2019 11:04:15 GMT

Hi,

have you tried with

date(field)?

Kashyap_R — Wed, 16 Oct 2019 11:20:38 GMT

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

Thanks