topic Re: date conversion in QlikView https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145970#M374975 <HTML><HEAD></HEAD><BODY><P>try like this </P><P></P><P>Date(Date_field,'YYYY-MM-DD')</P><P></P><P>or </P><P></P><P><SPAN style="font-size: 13.3333px;">Date(date#(Date_field),'YYYY-MM-DD')</SPAN></P></BODY></HTML> Mon, 08 Aug 2016 07:52:21 GMT avinashelite 2016-08-08T07:52:21Z date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145968#M374973 <HTML><HEAD></HEAD><BODY><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;">Hi all ,</P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;"></P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;">my date format is 20070624.</P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;"></P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;">i need 2007-60-24</P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;"></P><P class="loading smz-translated" style="font-size: 14px; font-family: Merriweather, serif; color: #333333;">please help me</P></BODY></HTML> Mon, 08 Aug 2016 07:44:03 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145968#M374973 2016-08-08T07:44:03Z Re: date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145969#M374974 <HTML><HEAD></HEAD><BODY><P>try this</P><P>date(Date#('20070624','YYYYMMDD'),'YYYY-MM-DD')</P></BODY></HTML> Mon, 08 Aug 2016 07:52:04 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145969#M374974 arulsettu 2016-08-08T07:52:04Z Re: date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145970#M374975 <HTML><HEAD></HEAD><BODY><P>try like this </P><P></P><P>Date(Date_field,'YYYY-MM-DD')</P><P></P><P>or </P><P></P><P><SPAN style="font-size: 13.3333px;">Date(date#(Date_field),'YYYY-MM-DD')</SPAN></P></BODY></HTML> Mon, 08 Aug 2016 07:52:21 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145970#M374975 avinashelite 2016-08-08T07:52:21Z Re: date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145971#M374976 <HTML><HEAD></HEAD><BODY><P>try belwo</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">date(Date#('Datefield','YYYYMMDD'),'YYYY-MM-DD') as new date</SPAN></P></BODY></HTML> Mon, 08 Aug 2016 08:06:04 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145971#M374976 Chanty4u 2016-08-08T08:06:04Z Re: date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145972#M374977 <HTML><HEAD></HEAD><BODY><P><STRONG>Date#</STRONG> will interpret the number as Date. By YYYYMMDD you're defining what kind of date format you have, helping QV to understand how the data is set.</P><P><STRONG>Date</STRONG> will now convert the data into format that you wish.</P><P></P><P>All the above solutions are correct and should work for you.</P></BODY></HTML> Mon, 08 Aug 2016 08:16:57 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145972#M374977 MindaugasBacius 2016-08-08T08:16:57Z Re: date conversion https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145973#M374978 <HTML><HEAD></HEAD><BODY><P>=(Date(Date#((20070624),'YYYYMMDD'),'DD-MM-YYYY'))</P></BODY></HTML> Mon, 08 Aug 2016 09:33:12 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/1145973#M374978 Anonymous 2016-08-08T09:33:12Z