SuiteScript – Filter Expression – Between Dates

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.

3 thoughts on “SuiteScript – Filter Expression – Between Dates

  1. Eric's avatar Eric says:

    Try using

    filters : search.createFilter({
      name : ‘trandate’,
      operator: search.Operator.WITHIN,
      values : [‘1/1/2024’, ‘1/31/2024’]
    })

    Like

Leave a comment