Group years in a List Box

[#1]

Hello,

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.

[fernandotoledo · Accepted solution]

See if your Date field is loaded as Text. In this way tou need to convert it in the script like

date#(Date_Field,'DD/MM/YYYY')

then the year () function will work

[#3]

It worked just fine!

Thanks a lot!

Valeuu!

[fernandotoledo]

Blz Amigo!