Date Filter selection

[dharis]

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. 

[rubenmarin]

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.

[dharis]

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

[dharis · Accepted solution]

Perfect ! Worked as required. Thanks again Rubenmarin