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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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