Script error - master calendar

[juleshartley]

Hi,

could anyone help with why I might be getting a script error with simple calendar build:

//DATE TABLE

//create a table with all dates between the start and end date

Let vEnd = Monthend(Today());

let vStart = AddYears('$(vEnd)',-1); //1 year of dates

Calendar:

Load  Text(Date(TEMPDATE,'DDMMYYYY')) as %Key_Date... ;

Load Date($(vStart) + RecNo()) as TEMPDATE autogenerate $(vEnd) - $(vStart) ;

The error seems to occur in the last line.

Thanks!

[juleshartley · Accepted solution]

Answered my own question again - it's the dreaded apostrophes!

Needs to be Load Date('$(vStart)' + RecNo.. etc