Week number to Monday of week

  • Thread starter Thread starter Corrine
  • Start date Start date
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.
 
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?
 
I played with it some more and got the answer I needed. Thank you for your
assistance.
 
Back
Top