How to get the week number of a particular date in Acces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to get the similar function weeknum() in excel in to Access.
Such that weeknum() of a particual date can be calculated in the expression
for query.

thanks
 
Format([MyDate],"ww")


Note: This is based on the week starting on Sunday. For the week starting on
Monday use:

Format([Date], "ww", 2)
 
Ken said:
How to get the similar function weeknum() in excel in to Access.
Such that weeknum() of a particual date can be calculated in the expression
for query.
Click to expand...


Or, if you want a numeric value instead of a string value:

DatePart("ww", datevalue)

Check Help for details on how to control the beginning of
week and year.
 
Back
Top