Date filter in Alteryx App

[praneshsapmm]

Hello there,

I am trying to extract data from SQL server with a posting date condition , which means that lines that are between the posting date from & to range must be extracted . 

Can someone let me know how to do it via Alteryx App using in-db tools and data entry user interface.

Thanks.

[pedrodrfaria]

Hi @praneshsapmm 

The set up would look something like this:

Two Calendar tools to update a single filter in DB tool. Need to obviously update the SQL code written to match with what you have.

[praneshsapmm]

Hi @pedrodrfaria ,

Thanks for the solution . But seems like there is a problem . When i provide the input of dates via a user interface , solution still takes the data available in filter . 

How to rectify this . 

THanks.

[Jonathan-Sherman]

Hi @praneshsapmm,

Once you've got your SQL filter condition in the in-DB filter tool you'll need to define how the date interface tools interact with the filter condition. This happens through the use of the action tools. If you look into the configuration of each action tool you'll need to make sure it's updating one of the dates in the filter condition. One action tool to update each date in the condition. Ensure the circled part in the screenshot below is highlighted (which tells the action tool which part of your filter tool you'll be affecting - in this case the formula) and use the "Replace a specific string" section at the bottom of the configuration pane.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Kind regards,

Jonathan