I have dates for ten years in my calender object. (I am using date field from database in calender object)
But i don't want to display all 10 years values in calender. I need to display just latest year (2015) values in my calender.
(date format in my calender: mm/dd/yyyy.)
In the script you can use a where statement like this:
Where Year(Date) = 2015;
On the front end you can use Petter Skjolden for both the list box as well as calendar object. They both give you the ability to enter expression instead of using a field name directly.
Use this expression: =If( Year ( Date ) = 2015 , Date ) give by Petter.