Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Answered my own question again - it's the dreaded apostrophes!
Needs to be Load Date('$(vStart)' + RecNo.. etc
Answered my own question again - it's the dreaded apostrophes!
Needs to be Load Date('$(vStart)' + RecNo.. etc