[AccessD] DatePart "WW"

Thanks Lambert,

This one is A97.

I did find that "Week: DatePart("ww",[creation_date],1,2)" will give me the 
numbers I need.  I'm just curious how the function Really works...What year 
does it start with...because the FirstDayOFYear constant I expected to give 
what I needed.

Thanks,

Mark A. Matte



>From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] DatePart "WW"
>Date: Thu, 24 May 2007 09:32:56 -0500
>
>Well 12/31/2006 *is* day 1 of the 53rd week of the year. It's just that
>there are no more days for that week: 7 * 52 = 364.
>
>datepart("WW",#1/1/2007#) gives 1 for me and datepart("d",#1/1/2007#) also
>returns 1. What version of Access are you using? (Just curious).
>
>Lambert
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Thursday, May 24, 2007 10:15 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] DatePart "WW"
>
>
>Hello All,
>
>I'm using datepart to get the week.  12/31/2006 I am having an issue...No
>matter what optional constant I use or change...I get Day1 of week 53... 
>and
>
>1/1/2007 shows as Day2 of week 1.  How do I get Day1 of Week1?
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>PC Magazine's 2007 editors' choice for best Web mail-award-winning Windows
>Live Hotmail.
>http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migratio
>n_HM_mini_pcmag_0507
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows 
Live Hotmail. 
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507