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.
