Expression to Return (Financial Year)

[alkesh_sharma]

Hello,

I have one field called Year and Another Called Financial_Year with Values 2014 and 2014-2015 respectively.

If I put an expression =Max(Financial_Year) its still returning me 2014, rather I want 2014-2014.

Thankyou...

[alexandros17 · Accepted solution]

Try this:

=MaxString(Financial_Year)

[hic]

The Max() function returns a number, e.g. 2014 or 2015. It cannot return a string. However if you define your financial years as duals, you can make it return the right number. See more on Fiscal Year.

HIC

[Anonymous]

Hi ,

Use this

RIGHT(LEFT( [SFinancial Year],4),2) & '-' & RIGHT(SubField([SFinancial Year],'/',2),2) AS FinancialYear,

[tresesco]

Try:

=FirstSortedValue(Financial_Year, -Year)