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!
CASE Statement
I doing a transaction search using a CASE statement. I want to find all Vendor Return Authorizations that are more than 45 days old but less than 190 days old. I have enetered the following in a Formula Numeric field:
CASE WHEN ({systemnotes.newvalue} = 'Pending Credit') THEN WHEN (to_number (to_date(2/13/2012)) – (to_date({systemnotes.date}) ))>45 THEN 1 ELSE 0 END
I get and error. I'm sure I'm not placing the parenthisis in the right places but can't figure out how. :h_a_w:
Any Help?