Brendan, I think your code is correct. My example is wrong :) Thanks, Jeff
-----Original Message----- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 5:03 PM To: CF-Talk Subject: RE: Week Number = date range ? according to CF's week function, week #38 in 2001 starts on sep/16, not #39 ? so the code i sent won't give you the result you want. ne'er mind b > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 16:56 > To: CF-Talk > Subject: Re: Week Number = date range ? > > > Jeff Green wrote: > > > Hi all, > > > > Anyone out there have some logic to figure out what date > range a particular > > week number is? > > > > Example: > > Week #39 in 2001 = sep/16 - sep/22 > > > > I thought I this working, but it blew up around week 52 and 53 :( > > > > I query for aggregate stats by the week, so the query > returns week number > > and year. > > > Just be carefull with the difference between a US weeknumber > and an ISO > weeknumber. For the latter, I am sure you can reverse > engineer the tag > at http://jochem.vandieten.net/coldfusion/customtags/ > > Jochem > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
