[AccessD] DatePart "WW"

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