Problem creating Calendar

[#1]

Hello,

can anyone tell me why this is wrong?

LET EndCalendar = YearEnd(today());

LET StartCalendar= '01.01.' & (Year(today())-1);

LOAD Date($(StartCalendar) + rowno() -1) as TempDate

AutoGenerate $(EndCalendar) - $(StartCalendar) + 1;

I am getting a mistake debugging and I can't see why

Regards and thanks in advance!

Stef

[#2]

PD: I am trying to create a calendar that contains the dates from the 1. January from last year until the 31. December of the current year..

[vijay_iitkgp · Accepted solution]

Hi Stef,

please use following script:

LET EndCalendar = Num(YearEnd(today()));

LET StartCalendar=Num(makedate((Year(today())-1),'01','01'));

LOAD Date($(StartCalendar) + RecNo() -1) as TempDate

AutoGenerate($(EndCalendar) - $(StartCalendar) + 1);

Regards

Vijay