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 ( GetAsNumber ( FiscalYrEnd_Txt );2) -1) / 100
& "-" & Right (FiscalYrEnd_Txt; 2)