topic Re: My date is not shown correct, maybe script error in QlikView

My date is not shown correct, maybe script error

Anonymous — Mon, 17 Aug 2015 10:07:40 GMT

Hi all,

I have a field in my xls stating the date in the format DD-MM-YYYY and when I display this it simply write a value.

I have tried to use the table list to give me the correct value, but without luck.

If I in the script write

date(date#([my date], 'DD-MM-YYYY'), 'DD-MM-YYYY') as MyDate,

I get the same problem.... why is that?

Thanks

Peter

Gabriel — Mon, 17 Aug 2015 10:11:00 GMT

Hi,

Date format is one of QlikView big issue. To best understand this issue please poast sample data with xls file

Mon, 17 Aug 2015 10:11:15 GMT

Check in source where that date field having number or text format

or else provide sample data

thanks

Anonymous — Mon, 17 Aug 2015 10:15:28 GMT

Stupid me, I looked in the xls and changed the format, saved it... and did a reload.....

Now it works

Thanks