topic Re: extraction of date and formatting in QlikView https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133014#M602323 <HTML><HEAD></HEAD><BODY><P>i currently did left(Blige_Disposal_Date,8) and for that my data is coming like&nbsp; 20161215..I want to have it in the form&nbsp; 2016-12-15 format..<IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213740_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 17 Sep 2018 13:42:48 GMT trishita 2018-09-17T13:42:48Z extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133011#M602320 <HTML><HEAD></HEAD><BODY><P>How can I extract the date in the format of yyyy-mm-dd from the given highlighted data</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213734_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 17 Sep 2018 13:11:13 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133011#M602320 trishita 2018-09-17T13:11:13Z Re: extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133012#M602321 <HTML><HEAD></HEAD><BODY><P>i did left(Disposal_Date, <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span> till now</P></BODY></HTML> Mon, 17 Sep 2018 13:31:16 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133012#M602321 trishita 2018-09-17T13:31:16Z Re: extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133013#M602322 <HTML><HEAD></HEAD><BODY><P>what Format is Disposal_Date ? Number?</P><P>then try</P><P><SPAN style="font-size: 8pt;"> left(text(Disposal_Date), <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span></SPAN></P></BODY></HTML> Mon, 17 Sep 2018 13:38:27 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133013#M602322 Anonymous 2018-09-17T13:38:27Z Re: extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133014#M602323 <HTML><HEAD></HEAD><BODY><P>i currently did left(Blige_Disposal_Date,8) and for that my data is coming like&nbsp; 20161215..I want to have it in the form&nbsp; 2016-12-15 format..<IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213740_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 17 Sep 2018 13:42:48 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133014#M602323 trishita 2018-09-17T13:42:48Z Re: extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133015#M602324 <HTML><HEAD></HEAD><BODY><P>you Need to Format it to your requirements.</P><P>date(date#(left(text(Disposal_Date), 8),'YYYYMMDD'),'YYYY-MM-DD')</P></BODY></HTML> Mon, 17 Sep 2018 13:46:06 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133015#M602324 Anonymous 2018-09-17T13:46:06Z Re: extraction of date and formatting https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133016#M602325 <HTML><HEAD></HEAD><BODY><P>Date(Date#(Sludge_Date, 'YYYYMMDD'),'YYYY-MM-DD')</P><P></P><P>Its working..anyways thanks</P></BODY></HTML> Mon, 17 Sep 2018 13:47:54 GMT https://community.qlik.com/t5/QlikView/extraction-of-date-and-formatting/m-p/133016#M602325 trishita 2018-09-17T13:47:54Z