CALCDATE weekdays

Reinhard
Reinhard Member Posts: 249
edited 2009-12-09 in NAV/Navision Classic Client
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!
Oztera

Comments

  • navbuff
    navbuff Member Posts: 4
    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
    Reinhard Member Posts: 249
    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)
    Oztera
  • DenSter
    DenSter Member Posts: 8,307
    Use the calendar functionality. There are date calculation functions in there that ignore non-working days.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories