Need help creating a 'date prompt'

[drcrane]

I have a file that has multiple days in it and I am trying to figure out if I can get the workflow to prompt the user to enter a date and then have it bring in only that day's worth of data.  It is comparing two files, one with date and one without.  When the output is created it is pulling everything for all the dates in the one file where an ID field matches between the two.  I want the final output to only pull the data related to those IDs for a specific date.  Thank you.

[atcodedog05]

Hi @drcrane 

Can you provide some sample data for better understanding 🙂

[Maskell_Rascal]

I take it this is an app or macro? If that's the case, I wouldn't have them enter a date, but I would instead have them select a date using the Date Interface tool. You can then use it to create a column in the incoming data and filter anything that doesn't match that date.

[Allan_F]

Agree with Maskell, if the data file is being pulled via SQL you can also have the Date Interface tool replace the Date Clause in the SQL Query to only pull that Date.

[drcrane]

Thanks. It looks like I was on the right path then.  I tried the Date Interface tool before but for some reason wasn't able to get it to work for me.  Just so you know, I'm very new to Alteryx programming.  I may have to ask more questions if I can't get the tool to work for me.  Thanks.

[drcrane]

Still having trouble with this.  I just don't think I'm configuring it right.  I've got it linked to a date field and I'm running it as an analytical app and it brings up the date box to chose a date but every time I chose 08/05/2021 the output still contains all the other dates from the file. 

[Allan_F · Accepted solution]

The Date Interface I am thinking should feed a Filter Tool instead of Select.

In the Action Tool of the Interface you would have it set to Update Value in the Operands section. The Filter would be set to a fixed value of which the Interface would update.

I am attaching a sample I made with created data.

[drcrane]

Thanks again to all for the help.  The filter is working perfectly now.  Thanks.