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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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

