Use the DayOfWeek(now) to get the day number, find out the difference to Tuesday and to a dateAdd for day to either go back in time. Then use the DateAdd of 3 weeks to get your result.
Regards, Andrew Scott http://www.andyscott.id.au/ > -----Original Message----- > From: Steve Sequenzia [mailto:c...@thinksys.com] > Sent: Friday, 3 September 2010 12:29 PM > To: cf-talk > Subject: Calculate next Tuesday 3 weeks from date > > > I need a little help with a ColdFusion function. I need to calculate the date of > the next Tuesday 3 weeks from the current date. > > I am assuming that I need to use the dateadd but I am not really sure how to > figure out the day thing. > > Any help with this would be great. > > -Steve > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- > Dinowitz/dp/1430272155/?tag=houseoffusion > Archive: http://www.houseoffusion.com/groups/cf- > talk/message.cfm/messageid:336799 > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/cf- > talk/unsubscribe.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm