Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
there's a way to allow the user to select only YEAR greater than 2015?
Thanks
How you want to assign this?
1) OnOpen Document
2) Fuzzy Search
3) after selection one year?
i just want that no one should be able to see Year lower than 2016
Hi,
Try This ;
=If(Year>=2016,Year)
if you don't want to show the data itself before 2016 apply the where condition in the script level .
if(year>2016,year) on the listbox
What is the logic behind, That means if some one select 2016 you need to display 2016 , 2017 ...
OR
You need to use default in listbox?
Well, probably the best thing is to change the script and don't load the data before 2016.
The reason is that data coming from year before 2015 are not validated - so i don't want to show nothing.
Perhaps this?
Load Field1, Field2, Year From Table Where Year > 2015;
another list box expression (on General tab / Field) might be:
Aggr(Only({1<YEAR={">2015"}>} YEAR),YEAR)
hope this helps
regards
Marco