Using filter in the record, count the days from date range

Hello romav0001 

Yes, you can do that. use custom record fields to calculate this. And for the filters you would need to have a range where the days should fall in between.

Can you please brifly explain how I can pass date from the Interface if range is created?

Something like above. Calculate the date difference using a custom record field and create a user filter.

Example code for User filter-Update accordingly

a!localVariables(
  local!days: a!forEach(
    items: enumerate(10) + 1,
    expression: fv!item * 100
  ),
  a!recordFilterList(
    name: "Number of Days",
    options: a!forEach(
      items: local!days,
      expression: a!recordFilterListOption(
        id: fv!index,
        name: concat("<", fv!item, " Days"),
        filter: a!queryFilter(
          field: 'recordType!KS Sample.fields.Days',
          operator: "<",
          value: fv!item
        )
      )
    )
  )
)

Custom field using sync-time evaluation. just a normal date difference by subtraction your last date and joining date and format using toInteger()

Something like above. Calculate the date difference using a custom record field and create a user filter.

Example code for User filter-Update accordingly

a!localVariables(
  local!days: a!forEach(
    items: enumerate(10) + 1,
    expression: fv!item * 100
  ),
  a!recordFilterList(
    name: "Number of Days",
    options: a!forEach(
      items: local!days,
      expression: a!recordFilterListOption(
        id: fv!index,
        name: concat("<", fv!item, " Days"),
        filter: a!queryFilter(
          field: 'recordType!KS Sample.fields.Days',
          operator: "<",
          value: fv!item
        )
      )
    )
  )
)

Custom field using sync-time evaluation. just a normal date difference by subtraction your last date and joining date and format using toInteger()

Thanks ,
I will try to use it .