Re: Calculate next Tuesday 3 weeks from date

2010-09-06 Thread Steve Sequenzia
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

Calculate next Tuesday 3 weeks from date

2010-09-02 Thread Steve Sequenzia
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

RE: Calculate next Tuesday 3 weeks from date

2010-09-02 Thread Andrew Scott
[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