Brian Dunning's FileMaker Custom Functions

FiscalYear ( TheDate ; FYStartMonth )

Enter a date and FY starting month and the function will give as result the fiscal year the date belongs to.

  Average rating: 3.9 (36 votes) Log in to vote

Mike Zarin   Mike Zarin
Mike Zarin Consulting
http://www.mikezarin.com

Share on Facebook Share on Twitter

  Sample input:
FiscalYear (4/25/05; 7)
  Sample output:
2005

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Enter a date and FY starting month and the function will give as result the fiscal year the date belongs to.

Also useful for academic years or any other non-calendar year that starts on the first of a month.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.