topic Re: How to convert the date in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575491#M214250 <HTML><HEAD></HEAD><BODY><P>Or something like this...</P><P></P><P>=Date(Date#('2013/01/01','YYY/MM/DD'),'YYYY-MMM')</P></BODY></HTML> Tue, 28 Jan 2014 09:09:18 GMT MK_QSL 2014-01-28T09:09:18Z How to convert the date https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575489#M214248 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my Database, the date format is 2013/01/01</P><P></P><P>How can I show it in QV with 2013-Jan?</P><P></P><P></P><P></P><P>Thanks.</P></BODY></HTML> Tue, 28 Jan 2014 09:06:54 GMT https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575489#M214248 2014-01-28T09:06:54Z Re: How to convert the date https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575490#M214249 <HTML><HEAD></HEAD><BODY><P>Date(YourDateField,'YYYY-MMM')</P></BODY></HTML> Tue, 28 Jan 2014 09:08:11 GMT https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575490#M214249 MK_QSL 2014-01-28T09:08:11Z Re: How to convert the date https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575491#M214250 <HTML><HEAD></HEAD><BODY><P>Or something like this...</P><P></P><P>=Date(Date#('2013/01/01','YYY/MM/DD'),'YYYY-MMM')</P></BODY></HTML> Tue, 28 Jan 2014 09:09:18 GMT https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575491#M214250 MK_QSL 2014-01-28T09:09:18Z Re: How to convert the date https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575492#M214251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year(YourDateField)&amp;'-'&amp;Month(YourDateField) as Date_field;</P><P></P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Divya</P></BODY></HTML> Tue, 28 Jan 2014 09:13:17 GMT https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575492#M214251 2014-01-28T09:13:17Z Re: How to convert the date https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575493#M214252 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use the following;</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MonthName</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">date</SPAN><SPAN style="font-size: 8pt;">),'YYYY-MMM') </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">HTH</SPAN></P><P><SPAN style="font-size: 8pt;">-Shruti</SPAN></P></BODY></HTML> Tue, 28 Jan 2014 09:13:58 GMT https://community.qlik.com/t5/QlikView/How-to-convert-the-date/m-p/575493#M214252 2014-01-28T09:13:58Z