Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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);
 shilpan
		
			shilpan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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);
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		And the vMin could be simplified using yearstart() parameter perhaps like:
let vMIN = num(YearStart(Today(),-1));
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks 
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Got it, thanks
