WEEKNUM function problem

[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.

 

[fredg]

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.

Probably because WeekNum is not an Access function.
If you wish the week number use:
=DatePart("ww",[DateField])

 

[Bruce M. Thompson]

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.

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

VBA.Format(date(),"ww")

 

[John Spencer (MVP)]

Because WeekNum is not an Access VBA function. Try using the DatePart function.

DatePart("ww",SomeDate)

 

[Bruce M. Thompson]

Probably because a "Weeknum()" function doesn't exist in Access 2000. To
derive

the week number, try:

VBA.Format(date(),"ww")

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