Thanks Costas, That is great.
My problem is that I have the dates set up in such a way... All weeks start on Monday week 14 = April 1 2002 week 15 = April 8 2002 week 16 = April 15 2002 ETC...... So I need to show week 15 and the surrounding weeks. Is there a better way to generate that type of date? by week number starting with Monday (euro style)? Thanks JON -----Original Message----- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:09 PM To: CF-Talk Subject: RE: Dates ....NOW() to define a range Easy... Use a conditional CFLOOP: <cfset currDate=dateadd('d', -14, now())> <cfset endDate =dateadd('d', 14, now())> <cfloop condition = "#currDate# LESS THAN #enddate#"> <cfoutput>#currDate#</cfoutput> <cfset currDate = dateadd('d', 1, currDate)> </cfloop> -----Original Message----- From: CF_JONNY [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:55 PM To: CF-Talk Subject: Dates ....NOW() to define a range Help! Any Ideas on how to return a range of dates using Now()?? I need to return week numbers around today's date including 2 weeks on each side? Jon _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
