Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Formula Help - Date of Last Customer Order
Can anyone tell me what is wrong with this formula? It comes from an example in Suite Answers. I am trying to search for all customers who have not placed an order in the last year (I would actually like all parent customers with no activity but that really has me stumped).
CASE WHEN ({today} - {lastorderdate} > 360) THEN 'T' ELSE ({today}-{lastsaledate} > 360) THEN 'T' ELSE Case WHEN (({lastsaledate} is null) and ({lastorderdate} is null)) THEN 'T' ELSE ‘F’ END END END
This is the error message I get.
"Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit."