Week Number from a start date

[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

 

[Philip Herlihy]

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

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

Phil, London

 

[John Spencer]

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
'====================================================