Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try one of the approaches discussed here: