Jan
You could create a temporary table and then put whatever dates you want in the table and then select the showlist col. Buddy CREATE TEMPORARY TABLE `TmpDayOfWeek` + (`ActualDate` DATE , + `IntDayOfWeek`= (IDWK(ActualDate)) INTEGER , + `IntWkOfYear`= (IWOY(ActualDate)) INTEGER , + `ShowList`= ((CTXT(ActualDate)) & '- day' & (CTXT(IntDayOfWeek)) & 'week' & (CTXT(IntWkOfYear))) TEXT (55)) From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Tuesday, December 02, 2008 11:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - List of Dates Group, 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
