A broader question is what constitutes the first week? If 1/1/xxxx falls on
a friday, is that week one, even though (assuming Sun is day one of the
week), or if it falls on Saturday, is that one day still week one?
since there are varying rules on this:
<:http://documentation.devexpress.com/#WindowsForms/DevExpressXtraEditorsRepositoryRepositoryItemDateEdit_WeekNumberRuletopic>
You will need to adopt a position on what is is...... ;-)
----- Original Message -----
From: "Javier Valencia" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, November 29, 2010 5:28 PM
Subject: [RBASE-L] - Re: Date Function
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
