This simple snippet of code gave me fits. Here is a working example of filtering by date range in a SuiteScript 2.0 filter expression.
The first thing you need to know is, don’t try to use the search operator “between” to filter a date range. It doesn’t work. Or I should say, it appears to work, but in reality, it ignores the filter altogether. Instead do this.

Thank you!
LikeLike
fyi NS uses ‘within’ instead of ‘between’ π
LikeLike
Try using
filters : search.createFilter({
β name : ‘trandate’,
β operator: search.Operator.WITHIN,
β values : [‘1/1/2024’, ‘1/31/2024’]
})
LikeLike