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 >> >> > > > >
