Strange result when applying date function on variable

[#1]

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.

Let vTSEndDate = num(MonthEnd(AddMonths(Today(),-1,0)),'0');

checktable:
Load
num(MonthEnd(AddMonths(Today(),-1,0)),'0') as EndDateFormula
,$(vTSEndDate) As vEndDate
,date(num(MonthEnd(AddMonths(Today(),-1,0)),'0'),'YYYYMMDD') as DateEndDateFormula
,date($(vTSEndDate),'YYYYMMDD') As DatevEndDate
Autogenerate 1;

[#2 · Accepted solution]

Hi,

Please find the attached QV file.

Regards,

Ravi

[#3]

So it should be "Se"t instead of "Let"! Thanks a lot