1 Reply Latest reply: Jun 12, 2015 7:50 AM by Stefan Wühl RSS

    Evaluate formula in script or application

    Andreas Erfurt

      Is it possible to evaluate a formula/function in a script or application?

       

      For example:

      Script

       

      Tab1:

      LOAD * INLINE [

          ReceiptDate, Formula

          "10.06.15", "AddMonth(ReceiptDate,1)"

          "12.06.15", "AddMonth(MonthStart(ReceiptDate),1)"

          "07.07.15", "date(ReceiptDate+ 15)"

      ];

       

       

      Tab2:

      LOAD ReceiptDate,

        Evaluate(Formula) as DueDate

      Resident Tab1;

      --------------------------------------------------------------------------------------------

      Application

       

      vDueDate (Variable):

      TEST1: $(=Formula)

      TEST2: $(Formula)

      TEST3: $('$(=Formula)')

       

      The Result is NULL or error.

      ---------------------------------------------------------------------------------------------

      Any other ideas?

       

      Thanks!