Hi All
I have a field month_n
if i click 0 , it will select current month.
if i click -1 , it will select Next month.
if i click -2 , it will select Next 2 month.
if i click -9 , it will select Next 9 month.
Now i like to make this become a list box.
which have 4 choice :-
if user select 0 , it will filter current month.
if user select -1 , it will filter current till next month.
if user select -2 , it will filter current till next 2 month.
if user select -9 , it will filter current till next 9 month.
Cacn some one share with me how to do it ?
I assume some thing like below :-
=IF([Month_n]<='0','0',
IF([Month_n]<='-1','-1',
IF([Month_n]<='-2','-2',
IF([Month_n]<= '-9','-9'
))))
But i don't know how to trigger month seelect.
Paul Yeo
Paul Yeo
