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

Does this filter syntax look right?  (The goal is to limit to transactions within the last 5 months):
    		filters.push(search.createFilter({
    			name : 'formulanumeric: CEIL(MONTHS_BETWEEN(SYSDATE,{trandate}))',
    			operator : 'BETWEEN',
    			values : ['1','5']
    		}));

Thanks in advance.

Install this .. <https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp>

Then, you can create/validate the search using the UI.  Once you're happy, this Chrome extension will show you the code.  Its brilliant.  Easily the most used tool I have.

try this:
`filters.push(search.createFilter({`
	`name : 'trandate',`
	`operator : search.Operator.AFTER,`
	`values : ['monthsago5']`
`}));`

<@U5FHY30BV> Great tip, and I actually did start with that tool and I love it.
<@UU565SASH> will try.  I definitely wouldn't have come up with that on my own.

<@UU565SASH> Following up.  That worked like a charm.  Really appreciate the tip.  I owe the delay to other unrelated nonsense.  Thank you.