Eric Schultz
03/06/2025, 8:29 PMCeligo AI
03/06/2025, 8:29 PMAI generated answer (using internal Slack threads):In SuiteScript, you can create a dynamic saved search that will find records where a Date/Time field is older than 30 days ago by using a relative date filter. Here is a general outline of how you can do this: 1. Create a new search or load an existing saved search. 2. Add a filter to the search for the Date/Time field you are interested in. 3. Set the operator for this filter to 'within'. 4. For the value of the filter, use a relative date string like '-30 days'. Here is a code sample that demonstrates this:
javascript
var search = require('N/search');
var mySearch = search.create({
type: search.Type.SALES_ORDER,
filters: [
['datecreated', 'within', '-30 days']
]
});
mySearch.run().each(function(result) {
// process each result
return true;
});
In this example, the search will return all sales orders that were created more than 30 days ago. You can replace 'datecreated' with the internal id of the Date/Time field you are interested in.
Please note that the relative date string '-30 days' is interpreted as '30 days ago to now'. If you want to find records where the Date/Time field is exactly 30 days ago, you can use a relative date string like '30 days ago'.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/06/2025, 8:30 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838100731
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830461383
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820687711
Celigo AI
03/06/2025, 8:30 PM