topic Convert Date to Text in QlikView https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981647#M335102 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P>How to Convert <STRONG> 7/29/2015 </STRONG>into<STRONG> 29-Jul-2015.</STRONG></P><P><STRONG>Regards</STRONG></P><P><STRONG>Sharath</STRONG></P></BODY></HTML> Mon, 24 Aug 2015 11:46:26 GMT 2015-08-24T11:46:26Z Convert Date to Text https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981647#M335102 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P>How to Convert <STRONG> 7/29/2015 </STRONG>into<STRONG> 29-Jul-2015.</STRONG></P><P><STRONG>Regards</STRONG></P><P><STRONG>Sharath</STRONG></P></BODY></HTML> Mon, 24 Aug 2015 11:46:26 GMT https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981647#M335102 2015-08-24T11:46:26Z Re: Convert Date to Text https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981648#M335103 <HTML><HEAD></HEAD><BODY><P>=Date(Date#('7/29/2015', 'M/DD/YYYY'), 'DD-MMM-YYYY')</P></BODY></HTML> Mon, 24 Aug 2015 11:47:38 GMT https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981648#M335103 jonathandienst 2015-08-24T11:47:38Z Re: Convert Date to Text https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981649#M335104 <HTML><HEAD></HEAD><BODY><P>Month1:</P><P>MAPPING </P><P>&nbsp; LOAD * inline</P><P>&nbsp; [</P><P>&nbsp; MonthNo,MonthCharacter</P><P>&nbsp; 1,Jan</P><P>&nbsp; 2,Feb</P><P>&nbsp; 3,Mar</P><P>&nbsp; 4,Apr</P><P>&nbsp; 5,May</P><P>&nbsp; 6,Jun</P><P>&nbsp; 7,Jul</P><P>&nbsp; 8,Aug</P><P>&nbsp; 9,Sep</P><P>&nbsp; 10,Oct</P><P>&nbsp; 11,Nov</P><P>&nbsp; 12,Dec</P><P>&nbsp; ];</P></BODY></HTML> Mon, 24 Aug 2015 11:49:08 GMT https://community.qlik.com/t5/QlikView/Convert-Date-to-Text/m-p/981649#M335104 gautik92 2015-08-24T11:49:08Z