topic Re: date format in QlikView https://community.qlik.com/t5/QlikView/date-format/m-p/1067184#M356743 <HTML><HEAD></HEAD><BODY><P>I resolved this by writing the below format.</P><P></P><P> date(Date#(datefield,'YYYYMMDD'),'MM/DD/YYYY')</P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Tue, 03 May 2016 20:10:07 GMT dandaanilreddy 2016-05-03T20:10:07Z date format https://community.qlik.com/t5/QlikView/date-format/m-p/1067183#M356742 <HTML><HEAD></HEAD><BODY><P>hello Qlik developers,</P><P></P><P>can someone help me in getting the data format as 'MM-DD-YYYY'. My data format is </P><P></P><P>20090629</P><P>20090630</P><P>20090701</P><P>20090703</P><P>20090706</P><P>20090707</P></BODY></HTML> Tue, 03 May 2016 19:51:19 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1067183#M356742 dandaanilreddy 2016-05-03T19:51:19Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/1067184#M356743 <HTML><HEAD></HEAD><BODY><P>I resolved this by writing the below format.</P><P></P><P> date(Date#(datefield,'YYYYMMDD'),'MM/DD/YYYY')</P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Tue, 03 May 2016 20:10:07 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1067184#M356743 dandaanilreddy 2016-05-03T20:10:07Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/1067185#M356744 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Date(Date#(DateField, 'YYYYMMDD'), 'MM-DD-YYYY') as DateField</STRONG></P><P><STRONG><BR /></STRONG></P><P>or</P><P></P><P><STRONG>Date(MakeDate(Left(DateField, 4), Mid(DateField, 5, 2), Right(DateField, 2)), 'MM-DD-YYYY') as DateField</STRONG></P></BODY></HTML> Tue, 03 May 2016 20:15:27 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1067185#M356744 sunny_talwar 2016-05-03T20:15:27Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/1067186#M356745 <HTML><HEAD></HEAD><BODY><P>Got it thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 May 2016 20:17:23 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1067186#M356745 dandaanilreddy 2016-05-03T20:17:23Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/1067187#M356746 <HTML><HEAD></HEAD><BODY><P>Great, please close the thread with marking the correct answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 May 2016 20:23:43 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1067187#M356746 sunny_talwar 2016-05-03T20:23:43Z