List Box with dates

[#1]

I have a list box with dates in the format of dd/mm/yyyy. I would like to be able to only show each year, ex: 2005, 2006, 2007, etc. only once. I would also like to do this for the months as well. If anyone could help I would greatly appreciate it.

[#2 · Accepted solution]

You can create an expression directly in the list box :

Year(   yourDatefield)

Month(   yourDatefield)

weekday(   yourDatefield)  to get days Mon, Tue,...

JJ

[#3]

Thank you!