Date Conversion Issue

[manpri7078]

Hi All,

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

http://community.qlik.com/thread/101730

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 · Accepted solution]

Don't use Date#, use simply Date

[jagan]

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.