Input manually the date in alteryx

[SH_94]

Hi community,

I would like to ask what tool that we can use to input the date dynamically every time we run the workflow and appreciate if you coud share the workflow on how to do it.

For instance, i would like to input the date in the relevant option field every time before i run the alteryx workflow. Hence, i plan to build the option available like the available date below

Date option 

2023-02-28

2023-03-31

2023-04-30

2023-05-31

Thank you for the help.

[ShankerV · Accepted solution]

Hi @SH_94 

It can be achieved with the help of Date Interface tool or Drop Down tool also.

Dropdown tool:

Date tool

But if you date tool, it will give the user option to browse any date in the calendar.

Many thanks

Shanker V

[OllieClarke]

Hi @SH_94 

A couple of approaches here: Firstly if you just want the current date in your workflow, then you can make use of the DateTimeToday() function which outputs the current date. If you need time as well, then DateTimeStart() will give the timestamp of when the workflow began.

If however you want to input a date from choice, then you want to convert your workflow into an Analytic App and make use of the Date Interface Tool. I've attached a very simple example below:

Hope that helps,

Ollie

[gautiergodard]

hey @SH_94 

here are two ways to do this using a date picker or drop down list option:

hope this helps!

[kiyaraoufi]

Is there a way to create a batch macro that changes a date text input for a workflow that circles through a series of dates and writes an output for each date?