School year automatic generation

[Mr. SLP]

I am working on a report and need it to show the current school year on it. So “2017-18” if it was printed between Aug 2017 and June 2018. Any suggestions on how I would accomplish this?


Sent from my iPhone using Tapatalk

 

[Mark_]

For the logic, you would be looking for something like the following;

IF Month(Now() > 7 then
   SchoolYear = Year(Now()) & " - " & Year(Now()) + 1
Else
   SchoolYear = Year(Now()) - 1 & " - " & Year(Now())
End If