Create Function to change WeekNo Start/Finish

  • Thread starter Thread starter NoodNutt
  • Start date Start date
N

NoodNutt

G'day ppl,

I would like to create a function that alters the WeekNo format to start
from July1 and finish on June 30, which is a financial year, & not the
calendar year.

Any assistance is appreciated

TIA
Mark.
 
This may be a "brute force" approach, but ...

If you added 26 to the WeekNo that Access generates, would you get the
number you're looking for?
 
NOTE: You might also need to use the Mod function to get the 1-52 you're
looking for.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Functions 4
Adding date fields to table design 3
storing week no after automatically inserted.. 3
Allocate an income payment over a date range (tax years) 7
A2K format - BeforeUpdate Question 3
Insert values into a table based on check box being on or off. 3
Expression changes (97 to 2000 version) 1
importing file names from a directory 4

Back
Top