I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

[rohitians]

I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

[khadeer]

Hi

Date(DateField,'DD-MM-YYYY')

[#3 · Accepted solution]

Date(Date#('2013-02-27','YYYY-MM-DD'),'DD-MM-YYYY')

OR

Date(Date#(datefieldname,'YYYY-MM-DD'),'DD-MM-YYYY')

[er_mohit]

try this

date#(date(Datefield,'YYYY-MM-DD'),'DD-MM-YYYYY')as Datefield

[hic]

vishwaranjan is right. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right.

HIC

[rohitians]

I have a chart with minimize option disabled on the dashboard and one more chart which can be minimi...thanks for previous reply..

[rohitians]

I have a chart with minimize option disabled on the dashboard and one more chart which can be minimi...for previous reply