Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All...
I have a list box with 11 years... but i have to show only bottom 8years every time (in this scenario from 2005 to 2012)... How can i achieve this
2015 |
2014 |
2013 |
2012 |
2011 |
2010 |
2009 |
2008 |
2007 |
2006 |
2005 |
Thanks...
Hi,
It is possible to create a Listbox on an expression. So you can select an expression, in your case,
=if (years>2004, years, )
instead of selecting the concerned field,
br
Paul
=if (years>2004, years, )
=if(years <= (vMinYear+7), years)
-> Now, only 8 years will be displayed, i.e. 2013, 2014, 2015 will be excluded.
If min year can very, create a variable that consists of the required min year:
=if(years <= (vMinYear+7), years)
Marc