topic Strange result when applying date function on variable in QlikView https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169373#M40194 <HTML><HEAD></HEAD><BODY><P>When running the following script, the contents of DateEndDateForumla and DatevEndDate are not the same. What am I doing wrong? I would like to be able to trust the vTSEndDate variable in all contexts.</P><P></P><P>Let vTSEndDate = num(MonthEnd(AddMonths(Today(),-1,0)),'0');</P><P>checktable:<BR />Load<BR />num(MonthEnd(AddMonths(Today(),-1,0)),'0') as EndDateFormula<BR />,$(vTSEndDate) As vEndDate<BR />,date(num(MonthEnd(AddMonths(Today(),-1,0)),'0'),'YYYYMMDD') as DateEndDateFormula<BR />,date($(vTSEndDate),'YYYYMMDD') As DatevEndDate<BR />Autogenerate 1;</P><P></P><P></P><P></P><BR /><BR /> <P></P></BODY></HTML> Fri, 20 Aug 2010 10:23:28 GMT 2010-08-20T10:23:28Z Strange result when applying date function on variable https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169373#M40194 <HTML><HEAD></HEAD><BODY><P>When running the following script, the contents of DateEndDateForumla and DatevEndDate are not the same. What am I doing wrong? I would like to be able to trust the vTSEndDate variable in all contexts.</P><P></P><P>Let vTSEndDate = num(MonthEnd(AddMonths(Today(),-1,0)),'0');</P><P>checktable:<BR />Load<BR />num(MonthEnd(AddMonths(Today(),-1,0)),'0') as EndDateFormula<BR />,$(vTSEndDate) As vEndDate<BR />,date(num(MonthEnd(AddMonths(Today(),-1,0)),'0'),'YYYYMMDD') as DateEndDateFormula<BR />,date($(vTSEndDate),'YYYYMMDD') As DatevEndDate<BR />Autogenerate 1;</P><P></P><P></P><P></P><BR /><BR /> <P></P></BODY></HTML> Fri, 20 Aug 2010 10:23:28 GMT https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169373#M40194 2010-08-20T10:23:28Z Strange result when applying date function on variable https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169374#M40195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please find the attached QV file.</P><P></P><P>Regards,</P><P>Ravi</P></BODY></HTML> Fri, 20 Aug 2010 10:50:02 GMT https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169374#M40195 2010-08-20T10:50:02Z Strange result when applying date function on variable https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169375#M40196 <HTML><HEAD></HEAD><BODY><P>So it should be "Se"t instead of "Let"! Thanks a lot <IMG alt="Wilted Flower" src="http://community.qlik.com/emoticons/emotion-52.gif" /></P></BODY></HTML> Fri, 20 Aug 2010 11:36:30 GMT https://community.qlik.com/t5/QlikView/Strange-result-when-applying-date-function-on-variable/m-p/169375#M40196 2010-08-20T11:36:30Z