topic Date Index in QlikView https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084460#M361120 <HTML><HEAD></HEAD><BODY><P>I'm trying to import some dates that are in the following 3-4 digit format: 115, 215, 315,... etc</P><P></P><P>Fore example:</P><P>115 (Jan 2015)</P><P>1115 (November 2015)</P><P>214 (February 2014)</P><P>913 (September 2013)</P><P></P><P>Anyone know a way to automatically format these dates so that they can be recognized by Qlikview as dates?</P></BODY></HTML> Wed, 27 Jan 2016 15:03:13 GMT lbunnell 2016-01-27T15:03:13Z Date Index https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084460#M361120 <HTML><HEAD></HEAD><BODY><P>I'm trying to import some dates that are in the following 3-4 digit format: 115, 215, 315,... etc</P><P></P><P>Fore example:</P><P>115 (Jan 2015)</P><P>1115 (November 2015)</P><P>214 (February 2014)</P><P>913 (September 2013)</P><P></P><P>Anyone know a way to automatically format these dates so that they can be recognized by Qlikview as dates?</P></BODY></HTML> Wed, 27 Jan 2016 15:03:13 GMT https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084460#M361120 lbunnell 2016-01-27T15:03:13Z Re: Date Index https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084461#M361121 <HTML><HEAD></HEAD><BODY><P>if len(yourfield)=3,</P><P> makedate(2000+right(yourfield,2), left(yourfield,1),</P><P>&nbsp; makedate(2000+right(yourfield,2), left(yourfield,2),</P></BODY></HTML> Wed, 27 Jan 2016 15:19:33 GMT https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084461#M361121 Anonymous 2016-01-27T15:19:33Z Re: Date Index https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084462#M361122 <HTML><HEAD></HEAD><BODY><P>Use below in your script..</P><P>Date(If(Len(Date)=3, Date#(Date,'MYY'),Date#(Date,'MMYY')),'MMM YYYY') as MonthYear</P></BODY></HTML> Wed, 27 Jan 2016 15:20:42 GMT https://community.qlik.com/t5/QlikView/Date-Index/m-p/1084462#M361122 MK_QSL 2016-01-27T15:20:42Z