Razzak and all, Thanks for jarring my memory. I had looked at the functions but at first glance didn't see how I might use themy.
I select vHolDate from a table of stored holidays and then apply SET VAR vLastWorkDay = ((DWE(.vHolDate))-1) -- this gives me the last working day of the week SET VAR vBeginWorkDay = (DNW(DWE(.vHolDate-7))) -- this gives the first working day of the week Now I can simply do an insert WHERE mydatecolumn BETWEEN .vBeginWorkDay AND .vLastWorkDay Jan -----Original Message----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 02 Dec 2008 11:34:31 -0500 Subject: [RBASE-L] - Re: List of Dates At 11:19 AM 12/2/2008, jan johansen wrote: >Looking for a slick way to find the dates Monday thru Friday of a week. >For example Christmas is Day 4 of Week 52. I need to populate a list so >the result dates should be >12/22/2008 - day 1 week 52 >12/23/2008 - day 2 week 52 >12/24/2008 - day 3 week 52 >12/25/2008 - day 4 week 52 >12/26/2008 - day 5 week 52 > >With the resultant list I can do a selected INSERT into a table. Jan, FWIW, take a look at the new DATE functions, including the following: . Integer Day of the Year (IDOY(date)) . Integer Week of the Year ((IWOY(date)) . Integer Days in a Month ((IDIM(date)) . Is Leap Year (ILY(date)) . Next Working (Business) Date (DNW(date)) . Next Weekend Date (DWE(date)) For a sample application to demonstrate the use of these new date functions, take a look at the following: 2008 SAT Sample Applications: http://www.rupdates.com/sat2008/ -- R:BASE 7.6 for Windows: Folder: C:\RBTI\2008_RBG76_SAT\NewDATEFunctions Database: NDateFun Command File: NewDATEFunctions.DAT -- R:BASE Turbo V-8 for Windows: Folder: C:\RBTI\2008_RBG8_SAT\NewDATEFunctions Database: NDateFun Command File: NewDATEFunctions.DAT Have fun! Very Best R:egards, Razzak.
