Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Search for Customers with New Projects
I am trying to come up with a search for customers who have projects this quarter whose last project was 3 years ago from the new project.
I have tried various ways to do this, and I assume it will involve a formula, but the trouble is getting the 2nd most recent project date for comparison.
I was able to pull a search for customers who did not have projects between 3 years and 3 months ago and whose most recent project is within the last 3 months. But, this is not precise enough. I need to know that the previous project was 3 years or more before the current project date, not 3 years ago from now.
0