Corrine said:
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)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
This formula will work if the week is in the current year (all on one
line):
DateAdd("ww",36-1,DateSerial(Year(Date()),1,1)) -
(WeekDay(DateAdd("ww",36-1,DateSerial(Year(Date()),1,1))) - vbMonday)
If the year is not the current year change the "Year(Date())" part of
the formula to "Year(THE YEAR NUMBER)." Substitute your year number or
a variable or a column (Field) name for "THE YEAR NUMBER."
Sometimes the intrinsic constants don't work in a query. If this
happens (the query returns the wrong value) you can change vbMonday to
the number 2.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSqGWDoechKqOuFEgEQIS6gCeNN58v+QNd78bUa0cx8p+tDoS7SMAoO9W
ZP/dJaht2Q0KOO2+HMkfTAkt
=RuXW
-----END PGP SIGNATURE-----
