Change Year (Now()) to Fiscal Year beginning Oct. 1st

[jzacharias]

Is there a way to change the Year(Now()) function in the criteria to begin October 1st instead of January 1st?

 

[pbaldy]

Not that I'm aware of. I'd use a function. Here's one out of a program I wrote for a university, just to give you an example.

Public Function SchoolYearStart(TestDate As Date) As Date
  If TestDate < DateSerial(Year(TestDate), 7, 1) Then
    SchoolYearStart = DateSerial(Year(TestDate) - 1, 7, 1)
  Else
    SchoolYearStart = DateSerial(Year(TestDate), 7, 1)
  End If
End Function

 

[jzacharias]

I will try that, Thanks

 

[pbaldy]

No problem, post back if you get stuck.