Ooops - that was supposed to be 325 in my example - not 525. I'm sure you knew what I was talking about though.
Adam. > -----Original Message----- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 12:09 PM > To: CF-Talk > Subject: RE: Seasonal Content > > > Since the first day of every year is January 1 (I think, I > hope), you should > be able to just use dateadd() to get your date range based on the two > day-of-year values you specify (ie. 525 - 4). If the second > value is less > than the first, you know to add 365 to it in your addition. > You can get the > current year using year(now()). > > Does that work? > > Adam. > > > > > -----Original Message----- > > From: Sean Daniels [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 05, 2002 10:06 AM > > To: CF-Talk > > Subject: Seasonal Content > > > > > > I want to have some seasonal content in an app I am building. > > The content > > will reside in a db and I want to query for it based on > > today's date. I am > > clear on how I could do this for a single year: simply put > > fields to search > > on for start and end dates and look for records where > > getdate() between > > start_date and end_date. However, next year these dates would > > be invalid. > > > > I'm sure there is some slick way to do this computation based > > on the current > > day of the year (1-365), but I'm not sure of how exactly to > > store the valid > > range. I could have content valid from day 27 through day 189 > > of the same > > year. Or, I could have content valid from day 325 through > day 4 of the > > following year. So a simple "between start_day and end_day" > > won't do the > > trick. > > > > Thanks in advance. > > > > - Sean > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Sean Daniels > > Director, Engineering > > Marketplace Technologies, Inc > > (T): 207.363.7374 > > (C): 207.332.6340 > > (F): 240.269.6319 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~ > > http://www.dealforce.com > > http://www.mergernetwork.com > > > > > > > ______________________________________________________________________ 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
