I'm trying to create a formuala that would determine the current school year which runs from August to May. Right now, I have it set up as a formula to determine the fall, and another to determine the spring, however, it isn't working. Any ideas?
This is what I have right now
If {@monthcurrentdate} = "8" or
{@monthcurrentdate} = "9" or
{@monthcurrentdate} = "10" or
{@monthcurrentdate} = "11" or
{@monthcurrentdate} = "12" then
year(CurrentDate + 1)
Else
year(CurrentDate)
This is what I have right now
If {@monthcurrentdate} = "8" or
{@monthcurrentdate} = "9" or
{@monthcurrentdate} = "10" or
{@monthcurrentdate} = "11" or
{@monthcurrentdate} = "12" then
year(CurrentDate + 1)
Else
year(CurrentDate)