topic Variable Date as a number in the load script in QlikView https://community.qlik.com/t5/QlikView/Variable-Date-as-a-number-in-the-load-script/m-p/961181#M966910 <HTML><HEAD></HEAD><BODY><P><BR />I have set a variable called 'Month End Date' and linked it to an input box.</P><P></P><P>When I enter a date in te input box, 31/08/2015 and enter in the LOAD script num($(Month End Date)) as [Month End]</P><P></P><P>Why wont this show as a number in a straight table.</P><P></P><P>I thought QV held dual conditions for dates, everythings gets stored as a number?</P></BODY></HTML> Tue, 29 Sep 2015 17:05:52 GMT tinkerz1 2015-09-29T17:05:52Z Variable Date as a number in the load script https://community.qlik.com/t5/QlikView/Variable-Date-as-a-number-in-the-load-script/m-p/961181#M966910 <HTML><HEAD></HEAD><BODY><P><BR />I have set a variable called 'Month End Date' and linked it to an input box.</P><P></P><P>When I enter a date in te input box, 31/08/2015 and enter in the LOAD script num($(Month End Date)) as [Month End]</P><P></P><P>Why wont this show as a number in a straight table.</P><P></P><P>I thought QV held dual conditions for dates, everythings gets stored as a number?</P></BODY></HTML> Tue, 29 Sep 2015 17:05:52 GMT https://community.qlik.com/t5/QlikView/Variable-Date-as-a-number-in-the-load-script/m-p/961181#M966910 tinkerz1 2015-09-29T17:05:52Z Re: Variable Date as a number in the load script https://community.qlik.com/t5/QlikView/Variable-Date-as-a-number-in-the-load-script/m-p/961182#M966911 <HTML><HEAD></HEAD><BODY><P>Probably because your variable is just a text. </P><P></P><P>Try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date#('$(Month End Date)','DD/MM/YYYY') as [Month End]</SPAN></P></BODY></HTML> Tue, 29 Sep 2015 17:11:25 GMT https://community.qlik.com/t5/QlikView/Variable-Date-as-a-number-in-the-load-script/m-p/961182#M966911 swuehl 2015-09-29T17:11:25Z