Correct date format in XML file

[#1]

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?

[alexandros17]

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

[#3]

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

[alexandros17]

In the loading

[#5]

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.