GetFiscalYear ( theDate ; fyMonth ; option )

Returns the fiscal year of a given a date

Be the first to rate this function Log in to vote

Philip McGeehan - Show more from this author
SMD Ltd
http://philipmcgeehan.com

Sample input:

GetFiscalYear ( "25/12/2020" ; 8 ; "" )
GetFiscalYear ( "25/12/2020" ; 8 ; "start" )
GetFiscalYear ( "25/12/2020" ; 8 ; "end" )

Sample output:

"2020/21"
01/08/2020
31/07/2021

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

Let( theFY = Year ( theDate ) + ( Month ( theDate ) >= fyMonth ) -1
;
     Case ( option = "start" ;
               Date ( fyMonth ; 1 ; theFY ) ;
           option = "end" ;
               Date ( fyMonth ; 0 ; theFY +1 ) ;
           /*else*/
               theFY & "/" & Right ( theFY ; 2 ) +1
     )
)

Based on Mike Zarin's function: https://www.briandunning.com/cf/224
but adapted for my needs

Comments

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

GetFiscalYear ( theDate ; fyMonth ; option )

Comments

Support this website.

Support this website.