Number of week in the year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos Saez - 13 May 2005 21:38 GMT

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.

Reply to this Message

tina - 13 May 2005 22:21 GMT

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

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

Reply to this Message

Carlos Saez - 15 May 2005 12:54 GMT

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

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

Reply to this Message