Filter update based on interface action (formula)

Question

Hi masters

I want to use the same interface action to filter many different sources.

The selected date from the interface is the filter for many different sources except for one, which is actually the selected date + 1 month.

Therefore, if I select date 05/31/2023, for one specific filter I want to use 06/30/2023 as the selected date for this filter.

Please refer to the attached workflow for better understanding.

Thanks

Felipe

Update_filter_with_Action_Formula.yxwz

npariso · Accepted Answer

Hi Felipe - this issue is occuring because the parameter that is being passed through the filter tool is in DateTime format and contains the time. You just want to filter on the date.

To fix this, change the formula in the action tool to: DateTimeFormat(datetimeadd([#1],1,"month"),'%Y-%m-%d')

Let me know if this works!

dsandmann · Accepted Answer

In order for this to not return an error, all that's needed is to wrap the existing formula in ToDate() like so ToDate(datetimeadd([#1],1,"month"))