Wanted ; month number of fiscal year

[Robert Collins]

I have had a search around and have found custom funtions to return a fiscal year from a date , but I require something that can return the month number of the fiscal year. my fiscal year starts on March 1st so that would be month 1 ect.

I have a field called month_number and Year aready in which to calculate from

any help would be appreciated

[comment]

Try:

Mod ( Month ( YourDate ) - 3 ; 12 ) + 1

---

BTW, the year can be calculated as:

Year ( YourDate ) - ( Month ( YourDate ) < 3 )

Edited July 25, 2008 by Guest

[Robert Collins]

excellent, thank you very much for that