financial year representaion

[#1]

Dear All

currently , we are showing fianancial year as  2011-2012  format.

which we are getting from yearname function.

We want to show that FY11-12. .

Is there any other way or have to work through substring function.

Regards

Pramod Kumar

[adhudson · Accepted solution]

Hi,

     I am not sure if any direct functions available as a solution for this.

     But you can always use subfield to achieve this like the below.

     lets say your financial year field is FinYear.

     'FY'&right(subfield(FinYear,'-',1),2)&'-'&right(subfield(FinYear,'-',2),2)

     Probably, the above script could be solution for this issue.

Regards

Andrew Hudson