Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Correct date format in XML file

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?

Tags (1)
4 Replies

Re: Correct date format in XML file

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

Not applicable

Re: Correct date format in XML file

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

Re: Correct date format in XML file

In the loading

Not applicable

Re: Correct date format in XML file

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.