I dont think that will work for me. I think I would need to know the date in order to use the tag, I dont have the date available. I have a week number and year, thats it. I need to determine the first day in that week and/or last day.
jeff -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 4:44 PM To: CF-Talk Subject: RE: Week Number = date range ? 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 ______________________________________________________________________ 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=coldfusiona 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
