topic Re: Date Filter selection in App Development

Date Filter selection

dharis — Sat, 16 Nov 2024 01:22:41 GMT

Hello.

I need a solution where I need to set date filter to automatically set filter for days before a set date.

where you can have a filter for a date, where you can enter a specific date and then a filter is applied for all dates prior to this date?

For example, we have a hold that we know will close on Oct 1. If I enter Oct 1,2020, then the filter should automatically select all orders with ESD (estimated ship dates) available in the filter before this date.

Re: Date Filter selection

rubenmarin — Sun, 27 Sep 2020 08:28:44 GMT

Hi, you can set the date using a variable or user selections in date field.

To retriueve date before the selcted date you can use set analysis

- Using variable: Sum({<DateField={"<=$(VariableName)"}>} Value)

- Using field: Sum({<DateField={"<=$(=Max(DateField))"}>} Value)

To use a variable you can use the variable object on Custom objects -> Dashboard bundle. To use a variable a normal filter can be used, also the Date picker object inside the same Custom objects -> Dashboard bundle.

Re: Date Filter selection

dharis — Sun, 27 Sep 2020 17:12:24 GMT

Thanks rubenmarin will give it a try and get back..

Re: Date Filter selection

dharis — Sun, 04 Oct 2020 08:39:28 GMT

Perfect ! Worked as required. Thanks again Rubenmarin