Date selection using date interface

[TheBIguy]

Hello All,

I have added date interface tool to my workflow and I am now trying to filter data based on user input date on interface tool

master data is 

Employe	EVENT_DATE
A	2021-08-06
B	2021-07-30
C	2021-06-30

Now I am putting a filter tool and making custom filter

[EVENT_DATE] = DateTimeFormat(DateTimeAdd('DATE1',-1,"days"), "%Y-%m-%d") 

I want the date interface tool to feed the date entered by user at DATE1 in the formula

ex:  if user selects 2021-06-30 then it should filter only 30th June data

Thanks in advance

[danilang]

Hi @TheBIguy 

The "ended by downstream tool" error usually occurs when you have a macro in your workflow and and don't connect anything to the macro output.  Designer realizes that the macro output isn't used, just runs one iteration and then gives the message.

Dan

[JamesRatac]

Hi @TheBIguy.

You are receiving the No Output Files message because you did not specify what output the app should give you. To do this, follow these steps:

1. From View, unhide the Interface Designer, or press Ctrl + Alt + D.

2. Go to properties (click the gear icon on the left), and then tick the box/es of the output that you want to display after running your application.

Cheers!