Week Number from a start date

  • Thread starter Thread starter Dave_FFM
  • Start date Start date
D

Dave_FFM

Hi there.

I was wondering if any of you could help me. I'm looking to create a report
based on completed work compared to the targetted amount.
So what i'm looking at is:

Weekly target figure (65) x current week number vs Actual completed work.

I have no problem with any of it apart from actually getting the current
week number.
The start date was 01/01/2009.

Thanks for any help

Dave
 
Dave_FFM said:
Hi there.

I was wondering if any of you could help me. I'm looking to create a report
based on completed work compared to the targetted amount.
So what i'm looking at is:

Weekly target figure (65) x current week number vs Actual completed work.

I have no problem with any of it apart from actually getting the current
week number.
The start date was 01/01/2009.

Thanks for any help

Dave
Click to expand...

You can get the week number as a string using the Format() function,
using the format string "ww". (Acc 2003).

Phil, London
 
Or use the DatePart function to return a number

DatePart("ww",Date())

Look up DatePart in VBA help as there are additional arguments that can
be applied to define how the week is calculated. For instance, what is
the first day of the week, how is the first week of the year defined.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top