Create New column with date select tool

[BENJAMIN2]

Hi, I have a report with a column for Hire dates. I am trying to add date select tool to select date range and filter hire dates that fall in that range.

How I am doing that:- Adding a new column with formula tool, then adding date select tool to replace the string of newly created column with date selected. The analytical tool is not generating any output.Action tool configurationFormula tool to create new columnIssue

[echuong1 · Accepted solution]

An easier method may be to use a formula tool.

In the example attached, I filtered for records between two dates. I then used the Date interface tool to allow a user to select the start and end dates, updating the two dates in the filter.

Your app may also not be returning anything because you don't have an output tool configured. If there is not an output, you can still view the results via Browse by enabling it in the interface designer. Go to view  > interface designer > settings and check it.

Hope this helps!

[BENJAMIN2]

Thanks, Your method was much easy, and yes you were correct my app was not returning anything as browse was not enabled in interface design > setting.