I have a problem where I need to calculate to the next date of a particular weekday. Let say:
Start_Date = Monday, 8th December 2008
Period= 4 Weeks
Calc_End_Date = Must be the weekday of the Start_Date in a Period of 4 weeks (=5th of January '09)
If I use the Date Function, Day (Start_date + 28), it doesn't work always because it calculates the day not the weekday.
How do I calculate the weekdays if I want to use the Date function?
Thanks