jaguar5554
asked on
Calculate Fiscal Year 7/1-6/30
I could use assistance with a date serial expression (to be used in an MS Access query) that will calculate a fiscal year 7/1 - 6/30.
ASKER
Thank you for the link; however, I reviewed the MS solution prior to submitting my question on EE's site. I'm looking for an expression that will calculate the fiscal year starting with July 1. I believe the MS site's expression calculates the fiscal year starting with July 15. Perhaps I missed something... Any assistance would be greatly appreciated. Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Something like this may return what you want
Note: Dates in 08/09 range would return 2009
Usage in Access Query
SELECT * FROM TABLE where FY(DATECOLUMN)=2009
Note: Dates in 08/09 range would return 2009
Usage in Access Query
SELECT * FROM TABLE where FY(DATECOLUMN)=2009
Public Function FY(ByVal InputDate As Date) As Integer
Dim y As Integer
y = Year(InputDate)
If Month(InputDate) >= 7 Then y = y + 1
FY = y
End Function
http://support.microsoft.com/?kbid=210249