Week number function

  • Thread starter Thread starter Tyler
  • Start date Start date
T

Tyler

In an Access query, is there a way to determine the week
number of a date? I've tried using the WEEKNUM function,
but I keep getting an error message telling me that it's
not a defined function. Should that function work?
 
Tyler said:
In an Access query, is there a way to determine the week
number of a date? I've tried using the WEEKNUM function,
but I keep getting an error message telling me that it's
not a defined function. Should that function work?
Click to expand...

? DatePart("ww", "3/25/04")
13

ww = week of year
 
Back
Top