My week numbers are coming from MS SQL 7.0 DATEPART(wk, myDate) function. myDate is my date of course :)
Does anyone know if MS SQL 7.0 week numbers correspond with CF 4.5 week numbers? Jeff -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 4:56 PM 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
