Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
List box expression: =If(YearField=Year(today()), MonthName(today())&' YTD' , YearField)
Update: PFA
List box expression: =If(YearField=Year(today()), MonthName(today())&' YTD' , YearField)
Update: PFA
Hi Rohan,
Try this:
pick( WildMatch(Year,'*2014*','*2013*','*2012*'),'2014 April YTD','2013','2012')
Thanks,
AS
If i get your question right, try this List Box Exp..
if(Year=Year(today()),Year(today())&' April YTD', Year)
Regards,
Prabhu
Hi,
you can try something similar.
Regards
ASHFAQ