topic Re: convert to yyyymm in QlikView https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901071#M1010491 <HTML><HEAD></HEAD><BODY><P>Try this: <STRONG>Text(Date(YourDateField,'YYYYMMDD'))</STRONG></P></BODY></HTML> Fri, 08 May 2015 07:11:32 GMT 2015-05-08T07:11:32Z convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901068#M1010483 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>how can ı convert DATE to YYYYMMDD format?</P><P></P><P>like to function in SQL &gt;&gt; to_char(date,'yyyymm')</P><P></P><P>thanks.</P></BODY></HTML> Fri, 08 May 2015 07:07:16 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901068#M1010483 Anonymous 2015-05-08T07:07:16Z Re: convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901069#M1010486 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="font-size: 8pt;">date(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">date#</SPAN><SPAN style="font-size: 8pt;">(date,'YYYYMMDD'),'YYYYMM') </SPAN></P><P></P></BODY></HTML> Fri, 08 May 2015 07:10:21 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901069#M1010486 Anonymous 2015-05-08T07:10:21Z Re: convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901070#M1010488 <HTML><HEAD></HEAD><BODY><P>Hi Hopes this helps </P><P>Date(Date#(DateField,'MM/DD/YY'),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YYYYMMDD </SPAN>')</P></BODY></HTML> Fri, 08 May 2015 07:10:43 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901070#M1010488 sunilkumarqv 2015-05-08T07:10:43Z Re: convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901071#M1010491 <HTML><HEAD></HEAD><BODY><P>Try this: <STRONG>Text(Date(YourDateField,'YYYYMMDD'))</STRONG></P></BODY></HTML> Fri, 08 May 2015 07:11:32 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901071#M1010491 2015-05-08T07:11:32Z Re: convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901072#M1010493 <HTML><HEAD></HEAD><BODY><P>The expression convert your date field in a string</P></BODY></HTML> Fri, 08 May 2015 07:14:18 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901072#M1010493 2015-05-08T07:14:18Z Re: convert to yyyymm https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901073#M1010494 <HTML><HEAD></HEAD><BODY><P>thanks this is more general expression.</P></BODY></HTML> Fri, 08 May 2015 07:17:58 GMT https://community.qlik.com/t5/QlikView/convert-to-yyyymm/m-p/901073#M1010494 Anonymous 2015-05-08T07:17:58Z