But your Monday test (or mine) is that you have to figure out where I forgot an IDQuotes character.
Bill On Mon, Nov 29, 2010 at 4:21 PM, Bill Downall < [email protected]> wrote: > Jan, > > I still don't know if your variable is a date or an integer, but here's an > example that might get you going. It finds the Monday before any date. The > hard-coded "1" is because monday is day-of-week number 1 > > select datecolumn, + > (idwk(datecolumn)) as `Integer_Day_of_Week`, + > (tdwk(datecolumn)) as `Text_Day_of_Week, + > (datecolumn - idwk(datecolumn) + 1) as `Previous_Monday` + > from tablename > > Bill > > > On Mon, Nov 29, 2010 at 4:16 PM, jan johansen <[email protected]>wrote: > >> 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]>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 >>> >>> >> >> >> >> >
