CALCDATE weekdays

Reinhard

Hi... wondering if anyone has the answer...

How can I add two weekdays to a date?

ie 12/04/09 (Friday) + 2WD should come out to 12/08/09 (Tuesday)

thank you!

navbuff

Newdate:=CALCDATE('+2WD',TODAY); //add 2 days to today's date

or

Newdate:=CALCDATE('+2WD',120409D); //add two days to 12/04/09

or

Newdate:=CALCDATE('+2WD',anydate); //add two days to anydate you specify

Hope this helps.

Jack

Reinhard

Jack... thank you. I did try that. I should have mentioned. I THOUGHT that it would work as well. However, when I try

Newdate:=CALCDATE('+2WD',120409D); //add two days to 12/04/09

newdate is 12/06/09. so it added two days (Saturday and Sunday) instead of two weekdays (Monday and Tuesday)

DenSter

Use the calendar functionality. There are date calculation functions in there that ignore non-working days.