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

`SELECT trandate` gives `'15-Apr-2021 0:00:00'` now whereas before it gave just `'15-Apr-2021'`

Can you use TRUNC(trandate) to get only the date part?

thing is, how do I find all the places it’s used in my code :disappointed:

Create a scheduled script. Within it, do a global search for 'File: %.js'. For each result, load the file, look for indexOf the problem function. Write the result to system notes or a file cabinet file. Works OK, but obviously won't pick up occurrences in locked bundles.

that wouldn’t work at all….it’s not a single function.  It’s wherever `trandate` was somewhere in a `SELECT` SQL.