3 Replies Latest reply: Jun 2, 2010 3:50 PM by Fernando Toledo RSS

    Group years in a List Box



      I need help to use the year from my date collum. I have a date format like DD/MM/YYYY.

      I'm having some problems to show only the year (such 1999, 2000) in my list box.

      I have just reached a point that shows me 01/01/2001,01/01/2002.... But I need to see only the YYYY.

      I've tried YEAR(), LEFT(), RIGHT(), but nothing worked.

      Anyone have idea how to show only the year?

      If it's does't clear enough, please be welcome to ask and I'll try to explain in other way.

      Thanks a lot.