Create a field with fiscal year

[AlreadyLost]

I need to create a field that is only going to display the fiscal year in my report..

Example: If the date is between 6/30/2000 to 7/1/2001, then my field would display 2000/2001. I need to display all those fiscal years that is between 6/30/2000 to 7/1/2001.

Anyone know what the formula should be?

 

[synapsevampire]

Try a cheat of:

if month(currentdate) < 7 then
totext(year(currentdate)-1,0,"")&"/"&totext(year(currentdate),0,"")
else
totext(year(currentdate),0,"")&"/"&totext(year(currentdate)+1,0,"")

-k

 

[AlreadyLost]

It works. Thanks.