Hi,
I have looked on the internet for the answer to this, and found loads of information, but i cant seem to pic out the answer i need from it all (I blame the thursday afternoon feeling!)
Basically, what i want to do is this:
I have a date (say a). I am outputing an e-mail with a 'timetable' which looks a bit like this:
Action 1 - a
Action 2 - a+2
Action 3 - a+7
etc
I have got this working fine, using DateAdd ("d",2,a) and so on, but i wanted to be able to just use working days (rather than saying e.g. Action 2 has to be done by a Sunday)
From what i found, i thought "w" might do the trick ("w",2,a) but that didnt seem to work.
There seem to be very few actual definitions of what all these date options mean (eg, w, ww, d, y) so im finding it a bit difficult to figure out which (if any) would work for me!!
Any information or help on this matter would be greatly appreciated.
Thank you!
I have looked on the internet for the answer to this, and found loads of information, but i cant seem to pic out the answer i need from it all (I blame the thursday afternoon feeling!)
Basically, what i want to do is this:
I have a date (say a). I am outputing an e-mail with a 'timetable' which looks a bit like this:
Action 1 - a
Action 2 - a+2
Action 3 - a+7
etc
I have got this working fine, using DateAdd ("d",2,a) and so on, but i wanted to be able to just use working days (rather than saying e.g. Action 2 has to be done by a Sunday)
From what i found, i thought "w" might do the trick ("w",2,a) but that didnt seem to work.
There seem to be very few actual definitions of what all these date options mean (eg, w, ww, d, y) so im finding it a bit difficult to figure out which (if any) would work for me!!
Any information or help on this matter would be greatly appreciated.
Thank you!