WeekNumber?

[RustyR]

I have a DB where each record had a Date field. I know in Excel you can use
the Weeknum() function to get the ISO week number for a given date.
Is there a way add a field in a Table that takes the date and converts it to
the week number?

Thanks in advance for any help!

Rusty

[MGFoster]

RustyR wrote:

I have a DB where each record had a Date field. I know in Excel you can use
the Weeknum() function to get the ISO week number for a given date.
Is there a way add a field in a Table that takes the date and converts it to
the week number?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I don't know if it gives the ISO week number, but the DatePart()
function can return the week of the year:

DatePart("ww", Date())

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHnMIechKqOuFEgEQJEywCfUU2t3T7y9ClyQ4JOazlHMh G8SS4AoN/7
3eZa4p8Bsr0tn8jbGdY6xfHU
=tiTe
-----END PGP SIGNATURE-----

[fredg]

On Wed, 23 Mar 2005 15:19:56 -0600, RustyR wrote:

I have a DB where each record had a Date field. I know in Excel you can use
the Weeknum() function to get the ISO week number for a given date.
Is there a way add a field in a Table that takes the date and converts it to
the week number?

Thanks in advance for any help!

Rusty

There is no need for an field in your table to store the week number.
As long as you have the date stored, you can always compute the week
number, in a query, form, or report.

=DatePart("ww",[DateField])

will return that dates week number, as will

=format([DateField],"ww")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[PC Datasheet]

FYI,

DatePart does not compute the ISO week number. For example, New Years day
was on a Saturday this year. DatePart("ww", #1/1/05#) would have returned 1.
On Monday, 1/3/05, DatePart("ww", #1/3/05#) would have returned 2. The ISO
week number for 1/1/05 to 1/4/05 is 1.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"MGFoster" <[e-mail]> wrote in message
news:SG*****************@newsread1.news.pas.earthl ink.net...

RustyR wrote:

I have a DB where each record had a Date field. I know in Excel you can use the Weeknum() function to get the ISO week number for a given date.
Is there a way add a field in a Table that takes the date and converts it to the week number?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I don't know if it gives the ISO week number, but the DatePart()
function can return the week of the year:

DatePart("ww", Date())

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHnMIechKqOuFEgEQJEywCfUU2t3T7y9ClyQ4JOazlHMh G8SS4AoN/7
3eZa4p8Bsr0tn8jbGdY6xfHU
=tiTe
-----END PGP SIGNATURE-----

[Douglas J. Steele]

DatePart (and Format, for that matter) both accept two additional optional
parameters:

firstdayofweek, which specifies the first day of the week. (the default is
Sunday)
firstweekofyear, which specifies the first week of the year. (the default
is the first week is assumed to be the week in which January 1 occurs.)

Does tweaking them fix the problem?

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

"PC Datasheet" <no****@nospam.spam> wrote in message
news:lm***************@newsread2.news.atl.earthlin k.net...

FYI,

DatePart does not compute the ISO week number. For example, New Years day
was on a Saturday this year. DatePart("ww", #1/1/05#) would have returned
1.
On Monday, 1/3/05, DatePart("ww", #1/3/05#) would have returned 2. The ISO
week number for 1/1/05 to 1/4/05 is 1.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"MGFoster" <[e-mail]> wrote in message
news:SG*****************@newsread1.news.pas.earthl ink.net...

RustyR wrote:

> I have a DB where each record had a Date field. I know in Excel you can use > the Weeknum() function to get the ISO week number for a given date.
> Is there a way add a field in a Table that takes the date and converts it to > the week number?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I don't know if it gives the ISO week number, but the DatePart()
function can return the week of the year:

DatePart("ww", Date())

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHnMIechKqOuFEgEQJEywCfUU2t3T7y9ClyQ4JOazlHMh G8SS4AoN/7
3eZa4p8Bsr0tn8jbGdY6xfHU
=tiTe
-----END PGP SIGNATURE-----