topic Re: Dateformat in dimension in QlikView https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679469#M246377 <HTML><HEAD></HEAD><BODY><P>Use below in your script for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate</SPAN></P><P>Date(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate,'YYYYMMDD'),'DD.MM.YYYY') as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate</SPAN></SPAN></P></BODY></HTML> Wed, 24 Sep 2014 07:42:06 GMT MK_QSL 2014-09-24T07:42:06Z Dateformat in dimension https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679467#M246375 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a statusdate as dimension. Values for the statusdate for ex.</P><P></P><P>statusdate</P><P>20130228</P><P>20130430</P><P>20130531</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">What I want is, for ex.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P>statusdate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; formatedStatusdate</P><P>20130228&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28.02.2013</P><P>20130430&nbsp;&nbsp;&nbsp;&nbsp; 30.04.2013</P><P>20130531&nbsp;&nbsp;&nbsp;&nbsp; 31.05.2013</P><P></P><P>Some hints?</P></BODY></HTML> Wed, 24 Sep 2014 07:30:21 GMT https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679467#M246375 qvhjenvo 2014-09-24T07:30:21Z Re: Dateformat in dimension https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679468#M246376 <HTML><HEAD></HEAD><BODY><P>date(date#('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">20130228', 'YYYYMMDD'), 'DD.MM.YYYY')</SPAN></P><P></P><P>replace 20130228 with statusdate</P><P>date(date#(statusdate<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">, 'YYYYMMDD'), 'DD.MM.YYYY')</SPAN></P></BODY></HTML> Wed, 24 Sep 2014 07:34:41 GMT https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679468#M246376 maxgro 2014-09-24T07:34:41Z Re: Dateformat in dimension https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679469#M246377 <HTML><HEAD></HEAD><BODY><P>Use below in your script for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate</SPAN></P><P>Date(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate,'YYYYMMDD'),'DD.MM.YYYY') as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">statusdate</SPAN></SPAN></P></BODY></HTML> Wed, 24 Sep 2014 07:42:06 GMT https://community.qlik.com/t5/QlikView/Dateformat-in-dimension/m-p/679469#M246377 MK_QSL 2014-09-24T07:42:06Z