i have a number field that is formatted as follows:
need to split out into two seperate fields called "FiscalMonth" & "FiscalYear". I can not find way to do this being a number field.
Fiscal month: 12 Fiscal year: 2014
fiscal month: 5 Fiscal Year: 2015