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.
Finding recently modified Customers
I'm building a system that synchronises the list of customers in NetSuite with a local database and want to run a script every hour to pull out those customers that have been added/modified in NS in the last 60 minutes.
However, when I include the following criteria in a search, it returns no results...
Dim customerModified As New SearchDateField customerModified.operator = SearchDateFieldOperator.after customerModified.operatorSpecified = True customerModified.searchValue = DateAdd(DateInterval.Hour, -2, Now()) custSearch.lastModifiedDate = customerModified
If I omit that, I get a list of customers. The only other criteria specified is...
Dim isActive As New SearchBooleanField isActive.searchValue = False isActive.searchValueSpecified = True custSearch.isInactive = isActive
0