Finding the beginning date of next 11 weeks including current week in access query
Posted on 2014-10-03
I'm trying to find the begging date of a week for 11 weeks including the current week.
Example now we are on the 40 week of the year and the date for the start of the 40 week is 9/28/2014
I would like to get the beginning date for the next 10 weeks including current weeks start date
I'm able to get current weeks using DateAdd("d",(CInt(Format(Date(),"w"))-1)*-1,Date()) not sure how I can get the next 10 weeks start date. I would appreciate any help.