[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Calculate Fiscal Year 7/1-6/30

Posted on 2009-03-30
Medium Priority
791 Views
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.
0
Question by:jaguar5554
• 2

LVL 120

Expert Comment

ID: 24024617
0

Author Comment

ID: 24024978
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!
0

LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 24024988
did you see this part

Option Explicit
Const FMonthStart = 6   ' Numeric value representing the first month
' of the fiscal year.
Const FDayStart = 16    ' Numeric value representing the first day of
' the fiscal year.
Const FYearOffset = -1  ' 0 means the fiscal year starts in the
' current calendar year.
' -1 means the fiscal year starts in the
' previous calendar year.
0

LVL 11

Expert Comment

ID: 24025025
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

``````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
``````
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
###### Suggested Courses
Course of the Month18 days, 1 hour left to enroll