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.
Suitescript search filter by date
Hi,
I want to do suitescript search to filter by transaction date
var filtersMain = new Array();
filtersMain[0] = new nlobjSearchFilter ('custrecord_kurspajak_currency', null, 'is', stCurrencyId);
filtersMain[1] = new nlobjSearchFilter ('custrecord_kurspajak_effectivedatestart', null, 'onorafter', nlapiGetFieldValue('trandate'));
filtersMain[2] = new nlobjSearchFilter ('custrecord_kurspajak_effectivedateend', null, 'onorbefore', nlapiGetFieldValue('trandate'));
this should return one record but it doesn't return any, does anyone have any suggestion how I have to put the date filter?
0