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

[atcodedog05]

Hi @TheBIguy 

Here is how you can do it.

Workflow:

You can configure action tool replace the set date. I am confused with your filter satement though 🤔

Hope this helps : )

[atcodedog05]

Hi @TheBIguy 

Another way is to reference the connection directly.

Workflow:

Hope this helps : )

[TheBIguy]

Thanks for your reply actually I run between dates with that filter formula so exactly if I have to put then

If user select 30 June so I have to show 29th June data then previou month last date and then previous quarter last date

So formula helps me jumping on those date if date tool will replace DATE1

[atcodedog05]

Hi @TheBIguy 

Similar to first method you must be able to replace Date1 present in the filter. Please find a reference workflow.

Hope this helps : )

[TheBIguy]

Hello @atcodedog05  Thanks for that solution it perfect but I don't know why it's failing when I am attaching the same with my workflow

as you can see above when I update filter with '2021-07-01' it gives me ENTRY_DATE as 30th JUN but same when I am replacing string with DATE1 through interface and selecting 1st July it has no output

[atcodedog05]

Hi @TheBIguy 

Its working for me. You can your input data the attached workflow and give it a try.

Workflow:

Hope this helps : )

[TheBIguy]

@atcodedog05 

I guess I am having a bad day it's not giving any output even I have converted that to Date type at select as it was DateTime

I have created this same thing previously what we are discussing today but I thought that I am missing onto something that's why posted here but it's the same as of yesterday's night! 😞

Felling sad now cause we are correct but somehow data is not picking.

[TheBIguy]

also I dont know this error ended by downstream andit is taking only one record I guess as input I have 120000 rows here in .yxdb

[atcodedog05]

Hi @TheBIguy 

I am not sure about error ended by downstream. You can post it has a new question maybe someone else might know what to do.