How do you guys work around this? I set one of my criteria like the following to exclude empty or otherwise bad dates:
filters[2] = new nlobjSearchFilter('custrecord_current_end_date', null, 'after','1/1/1990',null);
It works great except for users whose Date format preference doesn't have YYYY at the end. Seems to work with MMDDYYYY and DDMMYYYY equally well. If YYYYMMDD is used, an expected error is thrown.
Netsuite suggested using something like the following, but it throws an unexpected error no matter what format is used:
var myDate = nlapiStringToDate('1/1/1990');
filters[2] = new nlobjSearchFilter('custrecord_current_end_date', null, 'after', myDate, null);
They're looking for a solution now but I thought I'd try here.
Case #1438687: Script Causes Unexpected Error When Editing a Case