Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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