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 Help - Relative Dates in Formula
I've got some custom records that I'm trying to search that are basically a way of comparing a custom budget to a custom profit. The search needs to return all customers, regardless of if there is a transaction, so I can't use the date as a filter or customers with zero transactions in the filtered period will have their budgets omitted as well. So right now I have a search that comes up with budgets and results from our beginnings of NetSuite, and I need to filter them properly using the formulas.
The problem is that I don't know the proper syntax for relative dates inside formulas, and NetSuite's help about this stuff has been less than...helpful. Here's the formula I have right now: