Number of week in the year

[Carlos Saez]

I need to get the number of week in the year from a date. I've tried Format
(Adate; "ww") and a lot of ways more, included the specific spanish
sentences.
Any idea?.
Thank you.
Carlos.

 

[tina]

if you mean you want a count of the number of weeks between Jan 1 and a
specific date, try the DateDiff() function. see details in Access Help.

hth

 

[Carlos Saez]

For those dealing with spanish version, the parameter for number of week is
"ee" instead of "ww".
Carlos.