topic Re: date format conv in QlikView https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139928#M373701 <HTML><HEAD></HEAD><BODY><P class="">Field has a yearweek format Yyyy0ww</P><P class="">This week is like <A dir="ltr" href="https://community.qlik.com/" x-apple-data-detectors="true" x-apple-data-detectors-result="0" x-apple-data-detectors-type="telephone">2016030</A></P><P class="">I need to convert it as 201630</P></BODY></HTML> Mon, 25 Jul 2016 14:56:33 GMT qvqfqlik 2016-07-25T14:56:33Z date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139924#M373697 <HTML><HEAD></HEAD><BODY><P>how to convert a date year week format of a field </P><P>existin format&nbsp; is&nbsp; 2016030&nbsp; -&gt; yearweek</P><P>required as 201630</P><P>please help</P></BODY></HTML> Mon, 25 Jul 2016 14:33:15 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139924#M373697 qvqfqlik 2016-07-25T14:33:15Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139925#M373698 <HTML><HEAD></HEAD><BODY><P>Maybe like this..</P><P></P><P>=Dual(Left(2016030,4)&amp;right(2016030,2),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Left(2016030,4)&amp;right(2016030,2))</P></BODY></HTML> Mon, 25 Jul 2016 14:41:35 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139925#M373698 settu_periasamy 2016-07-25T14:41:35Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139926#M373699 <HTML><HEAD></HEAD><BODY><P>=WeekName(Today())</P></BODY></HTML> Mon, 25 Jul 2016 14:42:56 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139926#M373699 2016-07-25T14:42:56Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139927#M373700 <HTML><HEAD></HEAD><BODY><P>If you have a date field, this should work</P><P>=Date(WeekStart(yourdatefield),'YYYYWW')</P></BODY></HTML> Mon, 25 Jul 2016 14:46:28 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139927#M373700 Clever_Anjos 2016-07-25T14:46:28Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139928#M373701 <HTML><HEAD></HEAD><BODY><P class="">Field has a yearweek format Yyyy0ww</P><P class="">This week is like <A dir="ltr" href="https://community.qlik.com/" x-apple-data-detectors="true" x-apple-data-detectors-result="0" x-apple-data-detectors-type="telephone">2016030</A></P><P class="">I need to convert it as 201630</P></BODY></HTML> Mon, 25 Jul 2016 14:56:33 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139928#M373701 qvqfqlik 2016-07-25T14:56:33Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139929#M373702 <HTML><HEAD></HEAD><BODY><P>How do you create your yearweeek field?</P></BODY></HTML> Mon, 25 Jul 2016 15:00:27 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139929#M373702 Clever_Anjos 2016-07-25T15:00:27Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139930#M373703 <HTML><HEAD></HEAD><BODY><P class="">This field is coming from SAP and iam reading it in qv</P></BODY></HTML> Mon, 25 Jul 2016 15:15:24 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139930#M373703 qvqfqlik 2016-07-25T15:15:24Z Re: date format conv https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139931#M373704 <HTML><HEAD></HEAD><BODY><P>Please try</P><P>=replace(WeekName(MakeWeekDate(left(yourfield,4),Right(yourfield,2))),'/','')</P></BODY></HTML> Mon, 25 Jul 2016 15:56:03 GMT https://community.qlik.com/t5/QlikView/date-format-conv/m-p/1139931#M373704 Clever_Anjos 2016-07-25T15:56:03Z