My workflow includes a filter that selects data based on end date and start date. I have converted into analytic app by connecting to an action tool and including a calendar. However when I use the app and update the start and end date, the result is correct. It is taking all data for the entire year instead of the period i select. How to resolve this?
Solved! Go to Solution.
Hey @simasarry123 - the dates you have in your filter expression need to be placed in quotes I.e. ‘2022-11-16’
Then in your Action tools, you need to make sure that is only acting upon the start date in the expression (don’t include the quotes, so for the date I mentioned above you’d just have Replace a Specific String as 2022-11-16, not ‘2022-11-16’). Then just do the same for the other Action tool acting upon the end date.
Example here...
Dates:
Filter:
First Date/Action tool update only the quoted start date:
Likewise for the other Date/Action tool acting upon the quoted end date:
When we run:
Have attached the demo app so you can see what's going on - hope this helps.
Thank you so much . This worked.