Calculate Fiscal Year

[emncwundy]

Is there a date function that will automatically calculate a fiscal year?

I have a report that details quotes and their values. i want to sort the quotes by fiscal year (09/10 and then 10/11) and then sub sort by Month.

I have found the MonthName calculation, but cant find anything specific for fiscal year.

My searches through fmforums have found only complex fiscal year calculations. is there something simpler?

Edited April 7, 2010 by Guest

[comment]

When does your fiscal year start?

[emncwundy]

July 1

[comment]

Try:

Year ( date ) - ( Month ( date ) < 7 )

or, if you prefer:

Let (

y = Year ( date ) - ( Month ( date ) < 7 )

;

y & "/" & y + 1

)

The result is Number for the first one, Text for the other.

[emncwundy]

thanks so much. i tried the first one and it has solved my problem perfectly.