topic Re: Convert a number to date in QlikView https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716445#M1083175 <HTML><HEAD></HEAD><BODY><P>=date(date#('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">200903</SPAN>'),'YYYYMM'))</P><P></P><P>-Rob</P></BODY></HTML> Fri, 20 Jun 2014 04:08:19 GMT rwunderlich 2014-06-20T04:08:19Z Convert a number to date https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716442#M1083172 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I need your help to convert a number like 200903 to date format, how to do that?</P><P>I used date function: date(cur_date, 'YYYYMM'), cur_date variable has values of 200903, 200904...somthing like that. However I got 245001 as a result...Anyone knows why?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Fri, 20 Jun 2014 03:51:36 GMT https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716442#M1083172 2014-06-20T03:51:36Z Re: Convert a number to date https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716443#M1083173 <HTML><HEAD></HEAD><BODY><P>Try using date#</P></BODY></HTML> Fri, 20 Jun 2014 04:00:46 GMT https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716443#M1083173 sujeetsingh 2014-06-20T04:00:46Z Re: Convert a number to date https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716444#M1083174 <HTML><HEAD></HEAD><BODY><P>Try Date#</P></BODY></HTML> Fri, 20 Jun 2014 04:00:59 GMT https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716444#M1083174 2014-06-20T04:00:59Z Re: Convert a number to date https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716445#M1083175 <HTML><HEAD></HEAD><BODY><P>=date(date#('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">200903</SPAN>'),'YYYYMM'))</P><P></P><P>-Rob</P></BODY></HTML> Fri, 20 Jun 2014 04:08:19 GMT https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716445#M1083175 rwunderlich 2014-06-20T04:08:19Z Re: Convert a number to date https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716446#M1083176 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As all Say Date#() will help you</P><P></P><P>You use like this way</P><P>Date(Date#(YourDateFieldName,'YYYYMM'),'MMM-YYYY')</P><P></P><P>Regards</P></BODY></HTML> Fri, 20 Jun 2014 04:19:51 GMT https://community.qlik.com/t5/QlikView/Convert-a-number-to-date/m-p/716446#M1083176 PrashantSangle 2014-06-20T04:19:51Z