Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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?