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

K

Ken

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
 
P

PC Datasheet

Format([MyDate],"ww")


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

Format([Date], "ww", 2)
 
M

Marshall Barton

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