URGENT 500 pts:  How to calculate Fiscal Week in Microsoft Access Query

Posted on 2009-02-17
Last Modified: 2012-05-06
I'm trying to calculate the Fiscal Week in a select query based on a paydate.  My fiscal year starts on 6/28/2008 and runs through 7/3/2009.  The week starts on Saturday and ends on Friday.  Please tell me how to get the fiscal week in a select query with a calculation?

I'm setting at 500 pts because of urgency.

Question by:Awesome_MS
    LVL 28

    Expert Comment

    Very basic first stab as you have not detailed the full boudaries and requirements with regards to future years.

    FW: INT(datediff("d", DateSerial(2008,06,28), DateSerial(2008,06,28)+7) / 7) + 1

    Cheers, Andrew
    LVL 28

    Accepted Solution

    Forgot to add your field

    FW: INT(datediff("d", DateSerial(2008,06,28), [PayDate]) / 7) + 1

    Cheers, Andrew

    Author Closing Comment

    Very quick and perfect!!!  Thanks

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    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…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now