asked on

FM - Calc to Get a Fiscal Year Text

I used the below formula to create a text field with the fiscal year (I was given a year end date to the fiscal year). Only problem is that 10-11 reads as .1-11 because I thought the round function would force .1 to read as .10. Any suggestions?

Right (
Round (
(Right ( GetAsNumber ( FiscalYrEnd_Txt );2) -1) / 100
; 2)
; 2)

& "-" & Right (FiscalYrEnd_Txt; 2)

Will Loving

so "10-11" means October 11 is the last day of the fiscal year or is that supposed to mean the 2010-2011 fiscal year?

Will Loving

What does the input text for FiscalYrEnd_Txt look like?

rvfowler2

ASKER

10-11 is the Fiscal year 2010-11 (I'm trying to save space in the portal by using 2-digit years). The text for FiscalYerEnd/Txt is just a 4-digit year. I'm guessing that I've made this too complicated and overthought it.

ASKER CERTIFIED SOLUTION

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Will Loving

I think perhaps your confusion might be around doing math with numbers that originate in a text field. In general, you can do math within a calculation that has a text result, even when the value originates in a text field. Sometimes such as when doing greater than and less than comparisons where one or more values are originating from text fields, it's necessary to surround the value with GetAsNumber() in order for the comparison to work.

rvfowler2

ASKER

Yes, I didn't now that you could do any math with text. Calcs are my weakness and need to spend more time on it.