topic Date Conversion Issue in QlikView

Date Conversion Issue

manpri7078 — Fri, 13 Dec 2013 03:02:28 GMT

Hi All,

Yesterday I had posted a discussion thread, the link of which was as follows :

To this, Swuehi had given correct answer also.

Now my problem is that although the solution given was right, but when I am writing expression like given below in a textbox object :

Firstsortedvalue(Date,LME), it is giving me figure say 41365. Now I am modifying the expression as given below:

Date#(Firstsortedvalue(Date,LME),'DD-MM-YY'). It still shows the same result, instead of converting it to Date format.

The format in my date column is same, i.e. DD-MM-YY.

What may be the problem ?

Regards,

sebastiandperei — Fri, 13 Dec 2013 03:27:54 GMT

Don't use Date#, use simply Date

jagan — Fri, 13 Dec 2013 03:48:30 GMT

Hi Manish,

Date#() will parse the date from the given format and returns as numerice date, if you want Date then use

=Date(Firstsortedvalue(Date,LME))

Hope this helps you.

Regards,

Jagan.