Current Fiscal Year

[#1]

HI All,

How to get max of Fiscal year ?

I have data in this format.

2013-14

2014-15

2015-16

Regards,

Keerthi KS

[tresesco · Accepted solution]

MaxString(Fiscal_Year) ?

[#3]

Thanks Tresesco. I was no aware of this function.

[jagan]

HI,

If you have a date field then try like this

=Only({<DateFieldName = {'$(=Max(DateFieldName)'}>} Fiscal_Year)

or

MaxString(Fiscal_Year) as Tresesco suggested.

If it is a valid date field then you can directly use

Max(Fiscal_Year)

Regards,

Jagan.

[#5]

It is derived from datefield.

if(num(month(saledate))<=3,Year(saledate)-1&'-'&right(Year(saledate),2),Year(saledate)&'-'&right(year(saledate)+1,2)) as FiscalYear

saledate is the datefield

[tamilarasu]

You can also try like below,

Date(Max(Date#(FiscalYear,'YYYY-DD')),'YYYY-DD')