help in list box expression

[Anonymous]

Hi

i have list box containing Sales_date .It has date from 2011 to 2015.

I need the only years of the sales_date like year(Sales_date).I need only distinct values like 2011,2012,2013,2014,2015.

Thanks

[fred_s]

Hi,

Create a listbox

Field <Expression>

=year(YourDate)

So you found the answer yourself.

Grtz Fred

[MK_QSL]

While Loading data in script just below Sales_date create one more field

Year(Sales_date) as Sales_Year

now you can use Sales_Year field in List Box..

[fred_s]

Yep, Manish's answer is the way to go, but since rand knew the year() function, I've assumed it was not what he was looking for.

[Anonymous]

Hi Fred,

Thanks for reply ! But i need only distinct year values. I am getting multiple year values.

Thanks

[Anonymous]

Hi

Thanks for the reply !!

But i need only distinct year values. I am getting multiple year values.

Thanks

[fred_s]

Show us an example of what you would like to achieve.

This is what I get and to me it's pretty distinct:

[Anonymous]

Hi ,

I need the same as above .

Thanks

[PrashantSangle]

Hi,

What is your date format??

Regards,

[nagarjuna_kotha]

Hi,

Can U share ur sample Data  ?

Regards,

Nagarjuna