topic Date Problem in QlikView https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242524#M710697 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I am working from a csv file and I have a field that I want to use as a date.</P><P>I have tried about everything to make it display correctly as MMM-YYYY but it displays wrong always. I have used date, date# and other functions. It comes up with a date that does not exist yet Aug-2450. I have also attached the file I am loading from.</P><P></P><P>Please I need help a.s.a.p to continue my development as it should display as May-2011 or Apr-2011.</P><P></P><P>Thanks </P></BODY></HTML> Wed, 29 Jun 2011 14:17:20 GMT 2011-06-29T14:17:20Z Date Problem https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242524#M710697 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I am working from a csv file and I have a field that I want to use as a date.</P><P>I have tried about everything to make it display correctly as MMM-YYYY but it displays wrong always. I have used date, date# and other functions. It comes up with a date that does not exist yet Aug-2450. I have also attached the file I am loading from.</P><P></P><P>Please I need help a.s.a.p to continue my development as it should display as May-2011 or Apr-2011.</P><P></P><P>Thanks </P></BODY></HTML> Wed, 29 Jun 2011 14:17:20 GMT https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242524#M710697 2011-06-29T14:17:20Z Date Problem https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242525#M710698 <HTML><HEAD></HEAD><BODY><P> The YEAR_MONTH field has data is this format: 201105</P><P>When reading the data, you could try something like this:</P><P>Makedate(left(YEAR_MONTH,4),right(YEAR_MONTH,2),1) as YEAR_MONTH</P></BODY></HTML> Wed, 29 Jun 2011 14:22:59 GMT https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242525#M710698 m_woolf 2011-06-29T14:22:59Z Date Problem https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242526#M710699 <HTML><HEAD></HEAD><BODY><P>Thanks a lot.</P><P></P><P>It is working now <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 29 Jun 2011 14:28:56 GMT https://community.qlik.com/t5/QlikView/Date-Problem/m-p/242526#M710699 2011-06-29T14:28:56Z