Discussions
Saved Search Field Not Found error
Due to a change in our process, we need to change a saved search result result field as a formula(date) field that is computed as:
CASE WHEN {purchaseorder.createddate} < TO_DATE('06-01-2022', 'MM-DD-YYYY') THEN {purchaseorder.duedate} ELSE {purchaseorder.duedate}+7 END
This generates ERROR: Field Not Found
Any pointer on the above would be appreciated.
Separately, is there a console type environment where one can test expressions to determine where the issue issue (almost like an IDE).