topic Correct date format in XML file in QlikView

Correct date format in XML file

Fri, 01 Feb 2013 09:30:24 GMT

I have some XML files that I am loading into Qlikview. Here's a fragment from a node:

<Exclusion><StartDate>17/01/2003 00:00:00</StartDate><EndDate>24/01/2003 00:00:00</EndDate></Exclusion>

I've loaded them in but it looks like Qlikview is treating the date as a number rather than a proper date / time value - how should I format the XML so that Qlikview loads it properly?

Re: Correct date format in XML file

alexandros17 — Fri, 01 Feb 2013 09:32:25 GMT

Have you tried to format date after loading with date(xxxxxxx,"dd/MM/yyyy")

Re: Correct date format in XML file

Fri, 01 Feb 2013 09:34:30 GMT

Do I need to do that in the loadscript, or in the QV designer?

Re: Correct date format in XML file

alexandros17 — Fri, 01 Feb 2013 10:03:57 GMT

In the loading

Re: Correct date format in XML file

Fri, 01 Feb 2013 13:06:51 GMT

U can use this date(xxxxxxx,"dd/MM/yyyy") in both.

If u use this in QV designer, it creates performance issue.

If U use this in Load script , it increase the performance.

Regards,

KabilanK.