Work Week Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sap4ora - 06 Nov 2006 17:31 GMT

Hello,

Looking for a function or procedure to calculate work week based on Monday
as the first day of the week. For example Year (2006)

WW: 1
Date: 1/2/06-1/8/06

WW: 2
Date: 1/9/06-1/15/06

WW:34
Date: 8/21/06-8/27/06

Regards,

Reply to this Message

Douglas J. Steele - 06 Nov 2006 18:14 GMT

Try DatePart("ww", MyDateValue, vbMonday)

Note that there's a fourth parameter, as well, that lets you specify the
first week of the year (You can specify 1 to start with the week in which
January 1st occurs, 2 to start with the first week that has at least 4 days
in the new year or 3 to start with the first full week of the year)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello,
>
[quoted text clipped - 11 lines]
>
> Regards,

Reply to this Message

sap4ora - 06 Nov 2006 23:20 GMT

Thank you Doug.

> Try DatePart("ww", MyDateValue, vbMonday)
>
[quoted text clipped - 18 lines]
> >
> > Regards,

Reply to this Message