M mlh407 Registered User. Local time Today, 12:42 Joined Jun 24, 2005 Messages 26 Nov 6, 2005 #1 Hi all, I need to know how to calculate the week number. There are 52 weeks in a year. Given any date, I want to know what week number it is. Does anyone know how to do this in access? Mike
Hi all, I need to know how to calculate the week number. There are 52 weeks in a year. Given any date, I want to know what week number it is. Does anyone know how to do this in access? Mike
ssteinke for what it's worth Local time Today, 15:42 Joined Aug 2, 2003 Messages 195 Nov 6, 2005 #2 Format([Date],"ww")
R raskew AWF VIP Local time Today, 14:42 Joined Jun 2, 2001 Messages 2,734 Nov 6, 2005 #3 you might also lookup the DatePart() function, which provides some options as to how the week number is calculated. Bob
you might also lookup the DatePart() function, which provides some options as to how the week number is calculated. Bob
