Solved

Calculate Fiscal Year 7/1-6/30

Posted on 2009-03-30
4
773 Views
Last Modified: 2013-11-28
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
Comment
Question by:jaguar5554
  • 2
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 24024617
0
 

Author Comment

by:jaguar5554
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 119

Accepted Solution

by:
Rey Obrero earned 500 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

by:mildurait
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

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query to summarise data Like Pivot Table 3 29
Running sum query 6 32
Newbie needs help printing from a form. 10 20
Access database form in matrix view 14 10
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now