Input manually the date in alteryx

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.

Common Use Cases

Accepted answers

ShankerV

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

Dropdown.yxwz

Date 04042023.yxwz

All comments

ShankerV

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

Dropdown.yxwz

Date 04042023.yxwz

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

Date App.yxwz

gautiergodard

hey @SH_94

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

hope this helps!

New Workflow13.yxwz

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703