School year automatic generation (1 Viewer)

Mr. SLP · Mar 22, 2018

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_ · Mar 22, 2018

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

Code:

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

School year automatic generation (1 Viewer)

Mr. SLP

Registered User.

Mark_

Longboard on the internet

Similar threads

Users who are viewing this thread