Calendar tool in alteryx app

simasarry123

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?

Capture.JPG

DataNath

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.

Start and end date app demo.yxwz