Changing dates with the interface

[Greenlama254]

Hi all,

Still an Alteryx rookie here. At the moment I am trying to build an interface for my workflow. 

The flow is finished and so the dates are in the correct format I require. 

I connected the Date interface to the date formula I want to be able to change when running the app. However, when I check the output, the date is not changed. 

What am I doing wrong here?

(also, not sure if I even need the Datetime Parse function behind the formula, since the date is already in the desired format, but I am not sure the Date Interface recognizes dates in any format)

Any help would be much appreciated, thanks

Roger

[binuacs]

@Greenlama254 update your date tool action like below

[ShankerV · Accepted solution]

Hi @Greenlama254 

Please do not use Datetimetoday in the formula tool, as it contains the date without "" mark.

When new date is selected in Date tool, it is string and any string without "" mark will throw an error or wrong output.

Hance, I request you do the changes at 2 places to work accurately.

Change the formula like below:

DateTimeFormat("2023-02-28","%d/%m/%Y")

Then on the action tool, 

Output as expected:

Many thanks

Shanker V

[binuacs]

@ShankerV You are correct, I didn’t notice that, 

[Greenlama254]

Thanks for your input!

Have not been able to test this, but I will.

Really appreciate the help

Regards,
Roger

[Greenlama254]

Thanks for your input!

Have not been able to test this, but I will.

Really appreciate the help

Regards,
Roger

[Greenlama254]

that works like a charm!!

thanks a lot!!