This content has been marked as final. Show 4 replies
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?