User Input to be used as a variable

frankstar123

Hi,

I am trying to use Alteryx to create a report based on two dates;  i.e Where DateOfEntry >= '01-09-2017' and DateOfEntry <='30/09/2017'

I've added 2 user date pickers and actions to change the two dates without issue, thus a user defined report based on date.

However I want my output data to include two columns that use the two dates the user has defined, but i'm unable to access these two variables.

I have tried defining two new columns in a formula and then using the action to update the formula value for new columns but it doesnt work when ran as analytic app. 

Am i approaching this all incorrectly?

Thanks in advance

Frankie

andre347

You could create a text input with two date columns. Then use an action tool to update these two cells (on for each selection). Then use the Append Fields tool to add these new columns to your original data set.