Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Date(Date#('2013-02-27','YYYY-MM-DD'),'DD-MM-YYYY')
OR
Date(Date#(datefieldname,'YYYY-MM-DD'),'DD-MM-YYYY')
Hi
Date(DateField,'DD-MM-YYYY')
Date(Date#('2013-02-27','YYYY-MM-DD'),'DD-MM-YYYY')
OR
Date(Date#(datefieldname,'YYYY-MM-DD'),'DD-MM-YYYY')
try this
date#(date(Datefield,'YYYY-MM-DD'),'DD-MM-YYYYY')as Datefield
vishwaranjan is right. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right.
HIC