Fiscal Year

[simon4amiee]

Hi guys again,

I use the following criteria which returns the correct Fiscal Year (eg: 2015)

FYear: Year([ReferalDate])-IIf([ReferalDate]<DateSerial(Year([ReferalDate]),6,1),1,0)

What I'd like is for it to return 2015/2016 so I assuming somewhere in the above criteria I add a +1 also with &"/"& but just not sure where. Any ideas?

 

[simon4amiee]

Sorry guys got it in the end, but thought I'd share my solution, there is probably and easier way. Our financial year is April to April so had to change it slightly to get the required results:

FYear: Year([ReferalDate])-IIf([ReferalDate]<DateSerial(Year([ReferalDate]),4,1),1,0) & "/" & Year([ReferalDate])-IIf([ReferalDate]<DateSerial(Year([ReferalDate]),4,1),1,0)+1

 

[pbaldy]

An option would have been to use Month() and test for it being less than 4. Not sure if it would be more efficient, but I think so since there would be one function instead of two.

 

[namliam]

Wouldnt using dateadd be much easier?

year(dateadd("M", -3, referaldate)) & "/" & year(dateadd("M", 9, referaldate))