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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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