Got it. Thanks Andrew. >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/ > > >> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:336836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm