Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a List box based on the field "Year" at the moment it is going back to 2000, I only want it to show the Years that fall with in the last 13 months so I only want it to show 2009, 2010. It is currently showing 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010 which I do not want.
Thanks
You can use the below expression in the list box
if(Year>=year(addmonths(today(),-13)),Year)
Hi IvanDrago,
I think you can try make the expression listbox for this case.
Hi Ivan,
From which field you are picking your date. Does this contains years. If yes, you can split the year from you date and define separately in your script. Then create a listbox from the same. I think it would resolve your issue.
You can use the below expression in the list box
if(Year>=year(addmonths(today(),-13)),Year)
Where can you put this expression?
Go to list box properties.
You can see the <Expression> In the field drop down.
Have you a screen dump of this ? Because I cannot see anywhere where I can put this expression