topic Re: Date text into numeric value in QlikView https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518280#M1148459 <HTML><HEAD></HEAD><BODY><P>MakeDate()</P></BODY></HTML> Thu, 27 Jun 2013 20:09:03 GMT luciancotea 2013-06-27T20:09:03Z Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518279#M1148458 <HTML><HEAD></HEAD><BODY><P>Year and month in my data base are two distinct text columns.&nbsp; Is is anyway I can make transform that into numeric value so I can build a calendar scrip? Any ideas?</P></BODY></HTML> Thu, 27 Jun 2013 20:05:26 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518279#M1148458 2013-06-27T20:05:26Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518280#M1148459 <HTML><HEAD></HEAD><BODY><P>MakeDate()</P></BODY></HTML> Thu, 27 Jun 2013 20:09:03 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518280#M1148459 luciancotea 2013-06-27T20:09:03Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518281#M1148460 <HTML><HEAD></HEAD><BODY><P>you can use makedate() function and might possibly need to combine it with num#(). you can look up those functions in the reference manual. if you posted a sample qvw with some data if it would be easier to help you</P></BODY></HTML> Thu, 27 Jun 2013 20:10:27 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518281#M1148460 2013-06-27T20:10:27Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518282#M1148461 <HTML><HEAD></HEAD><BODY><P>Do something like this:</P><P></P><P>=Num(MakeDate('2013','01',1 ))</P><P></P><P>Just substitute '2013' with the year column and substitute '01' with your month column.</P><P></P><P>HTH.</P></BODY></HTML> Thu, 27 Jun 2013 20:55:03 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518282#M1148461 2013-06-27T20:55:03Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518283#M1148462 <HTML><HEAD></HEAD><BODY><P>Worked beautifully!&nbsp; Thank you so much!</P></BODY></HTML> Fri, 28 Jun 2013 17:25:41 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518283#M1148462 2013-06-28T17:25:41Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518284#M1148463 <HTML><HEAD></HEAD><BODY><P>Worked beautifully!&nbsp; Thank you so much!</P></BODY></HTML> Fri, 28 Jun 2013 17:25:51 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518284#M1148463 2013-06-28T17:25:51Z Re: Date text into numeric value https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518285#M1148464 <HTML><HEAD></HEAD><BODY><P>Worked great!&nbsp; Thank you so much!</P></BODY></HTML> Fri, 28 Jun 2013 17:27:04 GMT https://community.qlik.com/t5/QlikView/Date-text-into-numeric-value/m-p/518285#M1148464 2013-06-28T17:27:04Z