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.
 
Back
Top