dateformula

OnewayOneway Member Posts: 53
hi! guys

could u plz tell me how to evaluate a value to a dateformula varible?
and the initial value of it?

Comments

  • ara3nara3n Member Posts: 9,256
    Create a dateformular variable and compare to it. Also try 0df
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • BennoBenno Member Posts: 20
    Use the CalcDate function
  • David_CoxDavid_Cox Member Posts: 509
    To set a formula
    MyValue := '8D';
    EVALUATE(MyDateFormula,MyValue);
    or
    EVALUATE(MyDateFormula,'8D');

    To Return and use the DateFormula
    MyValue := FORMAT(MyDateFormula);
    MyDate := CALCDATE(MyValue,TODAY);
    or
    MyDate := CALCDATE(FORMAT(MyDateFormula),TODAY);
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • pdjpdj Member Posts: 643
    David Cox wrote:
    EVALUATE(MyDateFormula,'8D');
    (Old thread - sorry)
    Please always use '<8D>' when hardcoding dateformulas. Otherwise you code might fail or give incorrect results for users using a language where D isn't Days...
    Regards
    Peter
Sign In or Register to comment.