Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A bit silly but can anyone help in getting what's wrong with below script. I only want to use rowno()
let vMIN = num(AddYears(YearStart(Today()),-1));
let vMAX= num(YearStart(Today()));
Calender:load
Date($(vMIN)+RowNo()+1) as Temp_Date
AutoGenerate
$(vMIN)+RowNo()< $(vMAX);
Try this:
let vMIN = num(AddYears(YearStart(Today()),-1));
let vMAX= num(YearStart(Today()));
Calender:
load
Date($(vMIN)+RowNo()+1) as Temp_Date
AutoGenerate($(vMAX) - $(vMIN) + 1);
And the vMin could be simplified using yearstart() parameter perhaps like:
let vMIN = num(YearStart(Today(),-1));
Thanks
Got it, thanks