Fiscal Year In text Box

[upaliwije]

I have following List box  with Fiscal Years

FYear

2011/2012

2012/2013

2013/2014

and Fmonth list box contain the following

SEP

OCT

NOV

.....

.....

AUG

I have created two list box where I want the text to appear as follows depending on my selection

Text Box 1                    Text Box 2

Sep-2011 to Aug-2012   Sep-2012 to Aug-2013      (if  I select 2012/2013 as FYear)

Pls help me to write the expression

[upaliwije]

Will you please help me solve my issue

[Anonymous · Accepted solution]

Quick and dirty:

='Sep-'&LEFT('2011/2012',4)&' to Aug-'&RIGHT('2011/2012',4)

Replace '2011/2012' with e.g. ONLY(FYear).

And of course a LEFT(ONLY(FYear),4)-1 for previous year.

The "problem" is that any selection in Fmonth will NOT impact the text box, but I am not sure if you actually need that.

Kind regards

Niklas

[simondachstr]

In addition to that:

='Sep-'&LEFT('2011/2012',4)&' to '&Fmonth&'-'&RIGHT('2011/2012',4)

[upaliwije]

Thanks Both of You