topic Re: Cannot Convert Date string in QlikView https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704621#M673684 <HTML><HEAD></HEAD><BODY><P>Try with Left,Right and Mid functions to convert</P></BODY></HTML> Sun, 03 Aug 2014 08:37:53 GMT Anonymous 2014-08-03T08:37:53Z Cannot Convert Date string https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704620#M673683 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a set of data with the date field that I am converting to month, year and day</P><P></P><P>this is the format of the date 20100301</P><P></P><P>Year(INVDATE) as Year,</P><P>Month(INVDATE) as Month,</P><P>Day(INVDATE) as Day</P><P></P><P>The Month and Day fields are working correctly as required the year field is returning 56933 and 56934</P><P>I usually use this method and cannot understand why it isnt working for the year field im assuming this is the epoc date?</P><P>Please could you advise</P></BODY></HTML> Sun, 03 Aug 2014 08:29:16 GMT https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704620#M673683 rido1421 2014-08-03T08:29:16Z Re: Cannot Convert Date string https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704621#M673684 <HTML><HEAD></HEAD><BODY><P>Try with Left,Right and Mid functions to convert</P></BODY></HTML> Sun, 03 Aug 2014 08:37:53 GMT https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704621#M673684 Anonymous 2014-08-03T08:37:53Z Re: Cannot Convert Date string https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704622#M673685 <HTML><HEAD></HEAD><BODY><P>Thank you the left function solved my issue </P></BODY></HTML> Sun, 03 Aug 2014 08:44:57 GMT https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704622#M673685 rido1421 2014-08-03T08:44:57Z Re: Cannot Convert Date string https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704623#M673689 <HTML><HEAD></HEAD><BODY><P>Great,Pls close the conversation with answered</P></BODY></HTML> Sun, 03 Aug 2014 08:46:30 GMT https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704623#M673689 Anonymous 2014-08-03T08:46:30Z Re: Cannot Convert Date string https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704624#M673690 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try setting the format setting to date under the number tab on chart properties</P><P>regards</P><P>Padma </P></BODY></HTML> Sun, 03 Aug 2014 09:02:42 GMT https://community.qlik.com/t5/QlikView/Cannot-Convert-Date-string/m-p/704624#M673690 qlikoqlik 2014-08-03T09:02:42Z