Create a dynamic year array in formula

Creates an ascending array of years ending with this year. (2004, 2005, 2006, 2007, etc...)
Lotus Formula


thisyear := @Year(@Today);
yeararray := @Text(thisyear) ;
n := 1;

@While(n <= 60;
yeararray := @Text(thisyear - n) : yeararray;
n := n + 1);

yeararray

Written by Frank Joseph Brefere III

Posted by fbrefere001 on Wednesday April 18, 2007