Evaluate formula in script or application

[aerfurt85]

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!

[swuehl]

Try one of the approaches discussed here:

Inside field calculation?