We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now


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

Awesome_MS asked
Medium Priority
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.

Watch Question

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
Forgot to add your field

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

Cheers, Andrew

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Very quick and perfect!!!  Thanks
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.