topic Re: Date in MMM-YY fromat. in QlikView https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525645#M196471 <HTML><HEAD></HEAD><BODY><P>date(R_MonthYear,'MMM-YY')</P></BODY></HTML> Thu, 25 Jul 2013 15:36:42 GMT 2013-07-25T15:36:42Z Date in MMM-YY fromat. https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525644#M196470 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>When i tried to convert the date into MMM-YY format, i am getting the results as below. please let me know how to get it in MMM-YY format.</P><P><IMG __jive_id="44549" class="jive-image" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/44549_Capture.PNG" /></P></BODY></HTML> Thu, 25 Jul 2013 15:29:56 GMT https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525644#M196470 2013-07-25T15:29:56Z Re: Date in MMM-YY fromat. https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525645#M196471 <HTML><HEAD></HEAD><BODY><P>date(R_MonthYear,'MMM-YY')</P></BODY></HTML> Thu, 25 Jul 2013 15:36:42 GMT https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525645#M196471 2013-07-25T15:36:42Z Re: Date in MMM-YY fromat. https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525646#M196472 <HTML><HEAD></HEAD><BODY><P>Date(MonthYear,'MMM-YYYY')</P></BODY></HTML> Thu, 25 Jul 2013 15:37:57 GMT https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525646#M196472 nizamsha 2013-07-25T15:37:57Z Re: Date in MMM-YY fromat. https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525647#M196473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try date#(DATEFIELD,'DD-MM-YYY') as Datefield.</P><P></P><P>Hope this helps</P><P></P><P>Best Regards,</P><P>Gabriel</P></BODY></HTML> Thu, 25 Jul 2013 15:41:38 GMT https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525647#M196473 Gabriel 2013-07-25T15:41:38Z Re: Date in MMM-YY fromat. https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525648#M196474 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">date(R_MonthYear,'MMM-YY')</SPAN></P><P></P><P>But what is original format of <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">R_MonthYear</SPAN>? is in correct date format? if not, use</P><P>suppose <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">R_MonthYear</SPAN> is in MMMDDYYYY, then use like below</P><P><BR />date(date#(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">R_MonthYear</SPAN>,'MMMDDYYYY'),'MMM-YY')</P><P></P><P>hope it helps</P></BODY></HTML> Thu, 25 Jul 2013 18:42:36 GMT https://community.qlik.com/t5/QlikView/Date-in-MMM-YY-fromat/m-p/525648#M196474 MayilVahanan 2013-07-25T18:42:36Z