Jan, R:azzak's solution is a good start; however, you will need to tweak it depending on what you consider the first day of the week.. Outlook, for example considers Sunday the first day of the week, where many business would consider Monday instead. Also, if the year in question (1/1/xxxx) starts on Tuesday, there will be no Monday on the first week of that year and the Monday of that first week will indeed be the last Monday of the previous year.if that makes a difference. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected] _____
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, November 29, 2010 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Date Function Dennis, Bill and Razzak, Thanks for the input. I think I was overcomplicating it. Jan -----Original Message----- From: "jan johansen" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 29 Nov 2010 13:22:07 -0800 Subject: [RBASE-L] - Re: Date Function Perhaps a better way of stating it would be; Whatever .#DATE returns, I want to know what the date of the Monday in that week was. -----Original Message----- From: "jan johansen" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 29 Nov 2010 13:16:35 -0800 Subject: [RBASE-L] - Re: Date Function I'm playing with a variable. So if it was Wednesday of this week it would be Day 3 of week 49 and I would want to know Day 1 of week 49 which would be today. -----Original Message----- From: Bill Downall <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 29 Nov 2010 16:09:42 -0500 Subject: [RBASE-L] - Re: Date Function Jan, What do you already have as column or variable data about the week of the year? A date? A week number? Bill On Mon, Nov 29, 2010 at 4:00 PM, jan johansen < [email protected] <mailto:[email protected]> > wrote: Group, I'm looking for a combination of functions that will return the date of a Monday in any week of the year. Jan
