topic Re: Conversion date from YYYY-MM-DD to YYYYMMDD in QlikView https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920428#M983562 <HTML><HEAD></HEAD><BODY><P>Date( DateField, 'YYYYMDD') as NewDate</P></BODY></HTML> Wed, 12 Aug 2015 09:47:07 GMT tyagishaila 2015-08-12T09:47:07Z Conversion date from YYYY-MM-DD to YYYYMMDD https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920424#M983556 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">I am loading date field YYYY-MM-DD </P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">An example : 2014-02-10</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">How can I load date field as YYYYMDD ?</SPAN></P></BODY></HTML> Wed, 12 Aug 2015 08:49:30 GMT https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920424#M983556 Anonymous 2015-08-12T08:49:30Z Re: Conversion date from YYYY-MM-DD to YYYYMMDD https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920425#M983557 <HTML><HEAD></HEAD><BODY><P>Try to use like Date(Date#([Date Field], 'YYYY-MM-DD'), 'YYYYMMDD').</P></BODY></HTML> Wed, 12 Aug 2015 08:54:18 GMT https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920425#M983557 senpradip007 2015-08-12T08:54:18Z Re: Conversion date from YYYY-MM-DD to YYYYMMDD https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920426#M983559 <HTML><HEAD></HEAD><BODY><P>Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField</P></BODY></HTML> Wed, 12 Aug 2015 08:54:27 GMT https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920426#M983559 MK_QSL 2015-08-12T08:54:27Z Re: Conversion date from YYYY-MM-DD to YYYYMMDD https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920427#M983560 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hi try this <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date(Date#([Date ],'YYYY-MM-DD'),'YYYYMMDD') as temp_date,</SPAN></P></BODY></HTML> Wed, 12 Aug 2015 08:59:03 GMT https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920427#M983560 2015-08-12T08:59:03Z Re: Conversion date from YYYY-MM-DD to YYYYMMDD https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920428#M983562 <HTML><HEAD></HEAD><BODY><P>Date( DateField, 'YYYYMDD') as NewDate</P></BODY></HTML> Wed, 12 Aug 2015 09:47:07 GMT https://community.qlik.com/t5/QlikView/Conversion-date-from-YYYY-MM-DD-to-YYYYMMDD/m-p/920428#M983562 tyagishaila 2015-08-12T09:47:07Z