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!
Saved Search Formula numberical startdate
Hello,
I'm trying to populate numerical values in a Saved Search Formula (Numeric) where it shows me that value for any Sales Orders where {today} = {startdate}. I'm trying to create a similiar formula in another column where different values are shown when the {startdate} = ({today}+1) (or tomorrow, in other words).
Netsuite sent me this workaround but it only seems to work using the {datecreated} rather than the {startdate}:
case when round({today}-{datecreated}) between 0 and 0 then 7.5 when round(({today}+1)-{datecreated}) between 0 and 0 then 12 ELSE 3 END
I tried to simply replace {datecreated} for {startdate} and it didn't really work.