Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Want to create a column and update the closing date through Date tool

Srawat
8 - Asteroid

 

Hi,

 

Want to create a column and update the closing date  every month through date tool selection. Please advise.

 

 

Thanks,

5 REPLIES 5
Emmanuel_G
13 - Pulsar

@Srawat 

 

Can you give an input data and excepted output to test please ?

Qiu
21 - Polaris
21 - Polaris

@Srawat 
Maybe you are looking a Date interface tool for the Analytic Apps?

Date.PNG

Srawat
8 - Asteroid

Please refer below screen shot of sample data, I have prepaid expenses and yellow column closing date need to be changed every month, so I want to pick this date through Date tool. Is this possible? please advise.

 

Srawat_0-1664101758584.png

 

Thanks,

Emmanuel_G
13 - Pulsar

@Srawat 

 

Find in attachement the way of doing this.

 

As yo can see in the screenshoot below, I selected Sept 2, 2022 in Date tool for testing and it appears in the Month end date as you ask for.

 

Let me know if it works as there is any issue and do not hesitate to mark this answer as solution if it helped please.

 

Emmanuel_G_0-1664105650505.png

 

Srawat
8 - Asteroid

Thank you so much! It works fine.

Labels