values in a list box in different format

[rsdhavle]

HI,

In a list box of application for current year i want to show value as '2014 April YTD' and other values i need to show only year so the values in a list box will values in a different format like '2014 April YTD', 2013, 2012, 2011, 2010....and so on. Is it possible if yes how to do that?

[tresesco · Accepted solution]

List box expression: =If(YearField=Year(today()), MonthName(today())&' YTD' , YearField)

Update: PFA

[amit_saini]

Hi Rohan,

Try this:

pick( WildMatch(Year,'*2014*','*2013*','*2012*'),'2014 April YTD','2013','2012')

Thanks,

AS

[#4]

If i get your question right, try this List Box Exp..

if(Year=Year(today()),Year(today())&' April YTD', Year)

Regards,

Prabhu

[ashfaq_haseeb]

Hi,

you can try something similar.

Regards

ASHFAQ