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.
v2007.0: UNEXPECTED_ERROR searching lead records with a date filter
hi, i'm trying to return leads created within the last x days but my search gives an UNEXPECTED_ERROR for every variant i try... however it works fine if i use a filter for internalid, so i think it's just the filter that's wrong
var filters = new Array();
filters[0] = new nlobjSearchFilter('datecreated', null, 'on', 'today', null);
var columns = new Array();
columns[0] = new nlobjSearchColumn('internalid');
columns[1] = new nlobjSearchColumn('datecreated');
var result = nlapiSearchRecord('lead', null, filters, columns )
the datecreated field seems ok - it returns values like "08.03.2004 13:06" if i get hold of a record by its id
any ideas? i'm a bit stuck here...
0