I think I got you... something like... <cfset changeTable = "11/30/#year1#">
Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 09/24/02 19:29 PM >>> hmmmmmmm..... could you set an application/client variable, and set it to last until the time from now, until dec 21 midnight, then reset it every X hours or X minutes(once a year), or whatever, to gather the current year, and then on the year switch, trigger the other changes in the tables? tony -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 7:20 PM To: CF-Talk Subject: Dates... again OK, so stop the presses. Candace is stuck on dates again ;) I have a page where I want to display links for books coming out next month and through 11 months ahead. I am breaking these down by month/year using DateADD: <cfscript> month1 = DateFormat(DateAdd("m", +1, Now()), "mmmm"); month2 = DateFormat(DateAdd("m", +2, Now()), "mmmm"); month3 = DateFormat(DateAdd("m", +3, Now()), "mmmm"); month4 = DateFormat(DateAdd("m", +4, Now()), "mmmm"); month5 = DateFormat(DateAdd("m", +5, Now()), "mmmm"); month6 = DateFormat(DateAdd("m", +6, Now()), "mmmm"); month7 = DateFormat(DateAdd("m", +7, Now()), "mmmm"); month8 = DateFormat(DateAdd("m", +8, Now()), "mmmm"); month9 = DateFormat(DateAdd("m", +9, Now()), "mmmm"); month10 = DateFormat(DateAdd("m", +10, Now()), "mmmm"); month11 = DateFormat(DateAdd("m", +11, Now()), "mmmm"); month12 = DateFormat(DateAdd("m", +12, Now()), "mmmm"); year1 = DateFormat(DateAdd("m", +1, Now()), "yyyy"); year2 = DateFormat(DateAdd("m", +2, Now()), "yyyy"); year3 = DateFormat(DateAdd("m", -2, Now()), "yyyy"); year4 = DateFormat(DateAdd("m", -3, Now()), "yyyy"); year5 = DateFormat(DateAdd("m", -4, Now()), "yyyy"); year6 = DateFormat(DateAdd("m", -5, Now()), "yyyy"); year7 = DateFormat(DateAdd("m", -6, Now()), "yyyy"); year8 = DateFormat(DateAdd("m", -7, Now()), "yyyy"); year9 = DateFormat(DateAdd("m", -8, Now()), "yyyy"); year10 = DateFormat(DateAdd("m", -9, Now()), "yyyy"); year11 = DateFormat(DateAdd("m", -10, Now()), "yyyy"); year12 = DateFormat(DateAdd("m", -11, Now()), "yyyy"); </cfscript> Would there be a way to add a separator between months that occur in 2002 and months that occur in 2003? It will also need to remove the header for 2002 once January rolls around. I have a static page that currently does this: http://209.41.188.62/books/comingSoon.cfm But I need to do this on the fly because if not, I'll have to update the template once the new year rolls around. I'd appreciate any help or suggestions :) Thanks in advance! Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
