WEEKNUM function problem

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Anyone know why WEEKNUM function does not work on date
field when YEAR,Month,Day,WeekDay etc. work on the same
field?? Error msg says "undefined function in
expression". MSOWCF.DLL is present. Using Access 2000.
 
Anyone know why WEEKNUM function does not work on date
field when YEAR,Month,Day,WeekDay etc. work on the same
field?? Error msg says "undefined function in
expression". MSOWCF.DLL is present. Using Access 2000.
Click to expand...

Probably because WeekNum is not an Access function.
If you wish the week number use:
=DatePart("ww",[DateField])
 
Anyone know why WEEKNUM function does not work on date
field when YEAR,Month,Day,WeekDay etc. work on the same
field?? Error msg says "undefined function in
expression". MSOWCF.DLL is present. Using Access 2000.
Click to expand...

Probably because a "Weeknum()" function doesn't exist in Access 2000. To derive
the week number, try:

VBA.Format(date(),"ww")
 
Because WeekNum is not an Access VBA function. Try using the DatePart function.

DatePart("ww",SomeDate)
 
Probably because a "Weeknum()" function doesn't exist in Access 2000. To
derive
the week number, try:

VBA.Format(date(),"ww")
Click to expand...

Oh yeah ... and the "DatePart()" function works good too! <BG>
 
Back
Top