Script error - master calendar

juleshartley — Wed, 12 Feb 2014 11:52:25 GMT

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!

Re: Script error - master calendar

juleshartley — Wed, 12 Feb 2014 12:11:52 GMT

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

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