The best way would probably be to convert the Julian date, which is just the number of the day out of 365 days, and then add 7 to it using dateadd. There's a tag for converting to and from Julian dates at this URL.
http://www.zyxxy.com/cf_bit/julian/index.cfm?opt=julian&subID=4 ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 7:18 PM To: CF-Talk Subject: Week Number = date range ? 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. Thanks, Jeff ______________________________________________________________________ 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
