Week number to Monday of week

C

Corrine

I have a query from a Sharepoint list. The work week number is listed in a
column for text in a single line (just a two digit number). I would like to
query it in Access and find out what Monday's date for that work week would
be. Any suggestions would be helpful. (The users prefer to use work week
number)

thank you.
 
C

Corrine

Thank you for your help. Our first work week of the year starts on December
28th (2008) and it looks like you have it coded to start in August. Here are
the results of the query...
WW Monday
22 9/20/09
35 10/3/09
01 08/30/09
34 10/2/09
36 10/4/09

Any suggestions?
 
C

Corrine

I played with it some more and got the answer I needed. Thank you for your
assistance.
 

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

Need Monday date for given week number 4
Week, monthly, quarterly 2
Want the week number of a given date 5
Crosstab Queries by week 2
Convert week "number" to actual number to sort it in column headin 2
Extract data from previous week, previous two weeks, etc. 2
Week number and day number... 13
Convert dates to "week beginning.." dates 4

Top