Weeknum Function in Access

[KMdouglas]

I need to find a way to automatically caluclate what week of the year a date is contained in. Excel allows a WEEKNUM function to do this, and according to Access Help, access should too. However, when I try to the use this function I get a &quot;Undefined Function&quot; message. Could someone please help me out.<br>
<br>
Thanks,<br>
<br>
Kevin

 

[DougP]

Yes it does but its different<br>
x = Format(Now, &quot;ww&quot<br>
where x will be the number 4 for this week<br>
<br>
Look at these others too.<br>
CDate<br>
DateSerial

 

[DougP]

Make your own function<br>
<br>
Public Function WeekNum(Mydate)<br>
WeekNum = Format(Now, &quot;ww&quot<br>
End Function<br>

 

[DougP]

Sorry the above function should read<br>
<br>
Public Function WeekNum(Mydate)<br>
WeekNum = Format(Mydate, &quot;ww&quot<br>
End Function<br>