mibuso.com
Home› NAV/Navision Classic Client

calculation of date

kgsinhakgsinha Member Posts: 67
edited 2008-01-25 in NAV/Navision Classic Client
i want to calculate dat using dateformula and workdate.
i have written
Date:= Calcdate(1m,Workdate);
It adds 1 m in workdate, while i want to subtract 1m from current date.

Comments

  • BeliasBelias Member Posts: 2,998
    Maybe

    CALCDATE('-1M',WORKDATE);

    ?? :wink:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kgsinhakgsinha Member Posts: 67
    no this does not work
  • BeliasBelias Member Posts: 2,998
    don't forgot the ''
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kgsinhakgsinha Member Posts: 67
    it gives error msg
  • BeliasBelias Member Posts: 2,998
    Post it, plz...it works on my client :shock:

    ah..'M' uppercase
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • ufukufuk Member Posts: 514
    Try:
    CALCDATE('<-1M>',WORKDATE);
    Ufuk Asci
    Pargesoft
  • NaviDevNaviDev Member Posts: 365
    - Open Navision.
    - Click Help > C/Side Reference Guide.
    - In the Index Tab. Enter the work CALCDATE.
    Navision noob....
  • BeliasBelias Member Posts: 2,998
    Yes ufuk!i had completely forgot that :mrgreen::mrgreen:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.