Number of week in the year

  • Thread starter Thread starter Carlos Saez
  • Start date Start date
C

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.
 
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
 
For those dealing with spanish version, the parameter for number of week is
"ee" instead of "ww".
Carlos.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year and Week Totals 2
Extract data by week numbers for rolling 10 weeks 2
Week Numbers 1
Program Year vs Calendar Year - Tracking the weeks 1
Want the week number of a given date 5
payroll weeks / varying first day and week of the year 2
convert date to week, starting at financial year 2
calculated field. 1

Back
Top