topic Date time conversion function not working as expected in QlikView https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186443#M383849 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P>One of my qvd having 32 bit integer field with date in the format YYYYMM . I have loaded that column by converting it into date like Date#(Date_field) as NewDate</P><P></P><P>When i am trying to display it in chart dimension as Jan 2015 , Feb 2015 , etc., using expression MonthName(NewDate) it is throwing error. Is there any problem with my conversion Date# in the load script ? Please help.</P><P></P><P>TIA</P><P></P><P>James</P></BODY></HTML> Fri, 16 Sep 2016 09:31:02 GMT 2016-09-16T09:31:02Z Date time conversion function not working as expected https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186443#M383849 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P>One of my qvd having 32 bit integer field with date in the format YYYYMM . I have loaded that column by converting it into date like Date#(Date_field) as NewDate</P><P></P><P>When i am trying to display it in chart dimension as Jan 2015 , Feb 2015 , etc., using expression MonthName(NewDate) it is throwing error. Is there any problem with my conversion Date# in the load script ? Please help.</P><P></P><P>TIA</P><P></P><P>James</P></BODY></HTML> Fri, 16 Sep 2016 09:31:02 GMT https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186443#M383849 2016-09-16T09:31:02Z Re: Date time conversion function not working as expected https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186444#M383850 <HTML><HEAD></HEAD><BODY><P>Try convert the date like this:</P><P>Date(Date#(Date_field, 'YYYYMM'), 'YYYY-MM-DD') as NewDate</P><P></P><P>Then date functions start working.</P></BODY></HTML> Fri, 16 Sep 2016 09:32:47 GMT https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186444#M383850 MindaugasBacius 2016-09-16T09:32:47Z Re: Date time conversion function not working as expected https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186445#M383851 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.qlik.com/qlik-users/145582">mindaugasbacius</A>‌ ! Works Well !!</P><P></P><P>-James</P></BODY></HTML> Fri, 16 Sep 2016 13:06:52 GMT https://community.qlik.com/t5/QlikView/Date-time-conversion-function-not-working-as-expected/m-p/1186445#M383851 2016-09-16T13:06:52Z