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!
Date format conflicts in scripted searches: mmddyyyy vs yyyymmdd
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);