Alteryx Designer Desktop Discussions

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

Month adding to the data

SH_94
11 - Bolide

Dear community,

 

Would like to ask how we can add the additonal month to the current data dynamically as per example below:

SH_94_0-1662795362942.png

Thank you.

 

 

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @SH_94,

 

FrederikE_0-1662801917697.png

 

DataNath
17 - Castor

What's the logic here when you say dynamically? If it's just a case of adding a month then you can use the following Formula tool expression:

 

DateTimeFormat(DateTimeAdd(DateTimeParse([Month],'%b'),1,'month'),'%b')

 

DataNath_0-1662802075261.png

Labels