This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how does one filter a work order search by last modified date and time ```{"error":{"type":"error.SuiteScriptError","name":"SSS_INVALID_SRCH_FILTER","message":"An nlobjSearchFilter contains invalid search criteria: formuladatetime.","stack":["each(N/searchObject)","&lt;anonymous&gt;(/SuiteScripts/SS2/lib/WOSearch.js:377)","doGet(/SuiteScripts/SS2/restlet/RESTlet.js:28)"],"cause":{"type":"internal error","code":"SSS_INVALID_SRCH_FILTER","details":"An nlobjSearchFilter contains invalid search criteria: formuladatetime.","userEvent":null,"stackTrace":["each(N/searchObject)","&lt;anonymous&gt;(/SuiteScripts/SS2/lib/WOSearch.js:377)","doGet(/SuiteScripts/SS2/restlet/RESTlet.js:28)"],"notifyOff":false},"id":"","notifyOff":false}}```

just doing it *formulatedate* works but that's not granular enough.

my real search is more complex than this so i need a formula but seems formulatedatetime is not supported even though this field is definitely a datetime (e.g. comparing with *AFTER* operator works)  and docs say that formulatedatetime is an formula type.  so i'm gonna have to resort to SQL function and a formulanumeric?  b.s.  must be a better way