topic Re: How to change date format? in QlikView https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993851#M646599 <HTML><HEAD></HEAD><BODY><P>with the alt function</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105482_1.png" style="height: auto; width: auto;" /></P><P></P><P></P><P><EM>load </EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Date(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate), 'MMM-YYYY') as Invoicedate</STRONG> </EM></P><P><EM>inline [</EM></P><P><EM>Invoicedate</EM></P><P><EM>01-Apr-2014</EM></P><P><EM>01-May-2014</EM></P><P><EM>01-Jun-2014</EM></P><P><EM>42006</EM></P><P><EM>42007</EM></P><P><EM>42008</EM></P><P><EM>42010</EM></P><P><EM>];</EM></P><P></P><P></P><P></P><P></P><P>or, if you want the same result as Sunny</P><P></P><P><IMG alt="1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/105483_1.png" style="height: auto; width: auto;" /></P><P></P><P><EM>load Date(<STRONG>MonthStart</STRONG>(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate)), 'MMM-YYYY') as Invoicedate </EM></P><P><EM>......</EM></P></BODY></HTML> Fri, 13 Nov 2015 18:27:00 GMT maxgro 2015-11-13T18:27:00Z How to change date format? https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993848#M646596 <HTML><HEAD></HEAD><BODY><P>Hi all ,</P><P></P><P>I am having two date formats in single column:</P><P></P><P>Invoicedate</P><P>01-Apr-2014</P><P><SPAN style="font-size: 13.3333px;">01-May-2014</SPAN></P><P><SPAN style="font-size: 13.3333px;">01-Jun-2014</SPAN></P><P><SPAN style="font-size: 13.3333px;">42006</SPAN></P><P><SPAN style="font-size: 13.3333px;">42007</SPAN></P><P><SPAN style="font-size: 13.3333px;">42008</SPAN></P><P><SPAN style="font-size: 13.3333px;">42010</SPAN></P><P><SPAN style="font-size: 13.3333px;">How to change change this format to single format i.e, MMM-YYYY(ex: Apr-2015)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">thank you<BR /></SPAN></P></BODY></HTML> Fri, 13 Nov 2015 16:39:57 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993848#M646596 2015-11-13T16:39:57Z Re: How to change date format? https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993849#M646597 <HTML><HEAD></HEAD><BODY><P>May be like this..</P><P></P><P>Load Date(Alt( date#( Invoicedate , 'DD-MMM-YYYY' ),</P><P>&nbsp; Date(Invoicedate),</P><P>&nbsp; 'No valid date' ),'MMM-YYYY') as Date;</P><P>LOAD * Inline [</P><P>Invoicedate</P><P>01-Apr-2014</P><P>01-May-2014</P><P>01-Jun-2014</P><P>42006</P><P>42007</P><P>42008</P><P>42010</P><P>];</P></BODY></HTML> Fri, 13 Nov 2015 17:43:40 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993849#M646597 settu_periasamy 2015-11-13T17:43:40Z Re: How to change date format? https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993850#M646598 <HTML><HEAD></HEAD><BODY><P>Or this should also work</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><BR /></STRONG></P><P><STRONG>SET DateFormat='DD-MMM-YYYY';</STRONG></P><P></P><P><STRONG>Load <SPAN style="text-decoration: line-through;"><SPAN style="color: #ff0000; text-decoration: line-through;">Date</SPAN></SPAN><SPAN style="color: #ff0000;">MonthName</SPAN>(Invoicedate, 'MMM-YYYY') as <SPAN style="color: #ff0000;">MonthYear</SPAN>;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Invoicedate</STRONG></P><P><STRONG>01-Apr-2014</STRONG></P><P><STRONG>01-May-2014</STRONG></P><P><STRONG>01-Jun-2014</STRONG></P><P><STRONG>42006</STRONG></P><P><STRONG>42007</STRONG></P><P><STRONG>42008</STRONG></P><P><STRONG>42010</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="105477" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105477_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 13 Nov 2015 17:45:20 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993850#M646598 sunny_talwar 2015-11-13T17:45:20Z Re: How to change date format? https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993851#M646599 <HTML><HEAD></HEAD><BODY><P>with the alt function</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105482_1.png" style="height: auto; width: auto;" /></P><P></P><P></P><P><EM>load </EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Date(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate), 'MMM-YYYY') as Invoicedate</STRONG> </EM></P><P><EM>inline [</EM></P><P><EM>Invoicedate</EM></P><P><EM>01-Apr-2014</EM></P><P><EM>01-May-2014</EM></P><P><EM>01-Jun-2014</EM></P><P><EM>42006</EM></P><P><EM>42007</EM></P><P><EM>42008</EM></P><P><EM>42010</EM></P><P><EM>];</EM></P><P></P><P></P><P></P><P></P><P>or, if you want the same result as Sunny</P><P></P><P><IMG alt="1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/105483_1.png" style="height: auto; width: auto;" /></P><P></P><P><EM>load Date(<STRONG>MonthStart</STRONG>(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate)), 'MMM-YYYY') as Invoicedate </EM></P><P><EM>......</EM></P></BODY></HTML> Fri, 13 Nov 2015 18:27:00 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/993851#M646599 maxgro 2015-11-13T18:27:00Z