Date Filter between Months

[paulmagaling]

Is there any way to filter a list between months without the year?
e.g. April to September, October to March

[Dr Atul G- LNG]

Hi @paulmagaling 

OOTB it is not possible. 

[paulmagaling]

It seems impossible but, I found a way to overcome this requirement.

To get all records between specific month, I used the "trend" operator.

[Its_Azar]

Hi there @paulmagaling 

not with the out-of-the-box Date filter alone- not possible.
But yes, it is can be done with either relative date logic or a scripted/encoded query approach,  whats the usecase?

You can use a before query BR if you need it to be reusable 

(function executeRule(current, previous) {
  var m = new GlideDateTime().getMonthUTC() + 1;

  if (!(m >= 4 && m <= 9)) {
    current.addQuery('sys_id', 'ISEMPTY');
  }
})();

[paulmagaling]

For the platform analytics dashboard, I need to filter the asset_task table using the contract.ends, and get the records from this year's October to next year's March.