nearest dates using interface

Question

Hello Community,

Hope you could help with the problem.

So, let say we have the customer ABCD and selected one contract with signing date 24-10-2019.

Then we would like to identify all other contracts that were signed in near period (+/- 50 days from 24-10-2019).

Please see attached flow. The question is - is possible to enter the date throu interface so that it subsequently was pulled to formula tool or is there any other way to resolve the issue using interface with another toll?

Thanks a lot!

ABCD.xlsx

ABCD flow.yxmd

Qiu · Accepted Answer

@Vasyl11 
I hope this is what you need.

AngelosPachis · Accepted Answer

Hi @Vasyl11 ,

Two ways that pop to my head is to either use a date interface tool or a text interface tool.

The Date interface tool will allow for a calendar to appear in the interface, from which the user can select any date. The text box will allow your user to type anything, so you should make sure that whatever they type is in a date format (i.e. yyyy-mm-dd) else your workflow will error.

Also, in the action tools you have to select which expression of the formula you want to replace; as you can see from the screenshot above, I have selected to replace the date under the Signing date tested column.

Finally, because of the interface tool, your workflow will be converted to an app (suffix .yxwz) and you will only be able to run it as such if you double click on it. If you want to edit the underlying workflow, you can right-click on the app and select edit, or drag and drop the app on your Alteryx Designer instance

Hope that helps

Vasyl11 · Accepted Answer

Thank you!