Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Populate Month year in a column

Tid14
8 - Asteroid

Hi All,

I am working on  a Workflow where I am stuck with a Date time function so need help in that regard.

I want to populate this PQR Column in a way so that it gives me Previous month, and then current year (22), and then we can add the test to it incurred expenses.

 

ABC PQR
1May 22 Incurred expenses
2May 22 Incurred expenses
3May 22 Incurred expenses
4May 22 Incurred expenses
5May 22 Incurred expenses
6May 22 Incurred expenses
7May 22 Incurred expenses
8May 22 Incurred expenses
9May 22 Incurred expenses
10May 22 Incurred expenses

 

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

Hey @Tid14,

Heres one way to do this:

IraWatt_0-1656501852005.png

The first formula gets last month in your format and the second add on the extra " Incurred expenses".

Any questions or issues please ask :)
HTH!
Ira

 

 

 

Labels