Regarding Dynamically change year and month in alteryx

[PiyushJain]

Hi Team 

Good Morning, 

This is regarding dynamically changed year and month formulas in alteryx. 

My requirement is : Every month i need to replace month automatically and then workflow run as per scheduled time.

I refer the relevant articles/ post,but unfortunately i am not able to resolve my issue.

Actually in my case ,

Below 2 coloumns are coming from database:

1. Year

2. Mon

( There is no proper date coloumn coming from Database) 

I referred related articles and found there is a proper date in ddmmyyyy format. 

But in my case i have only above 2 coloumns.

How can i use these 2 coloumns and dynamically change the months.

Please advise

Regards 

Piyush J

[atcodedog05]

Hi @PiyushJain 

[Is last Month] is already the calculation which is checking whether its last month or not and giving or no. Please refer the workflow.

Hope this helps : )

[PiyushJain]

I created one coloumn named " Previous Month Only" which shows output as 12.

Now i   used ur formula for " no" 

My month coloumn "Mon" supposed to show 12 only.

But i am geeting 1,2,3,4  like till 12 in "Mon"coloumn. 

So as i say earlier i need some relation to connect my "Mon" coloumn and "Is last month" column together.

Please suggest.

Regards

Piyush J

[atcodedog05]

Hi @PiyushJain 

Don't use those formulas. Directly connect your flow input to the formula in the attached workflow. Let me know if you facing issues.

Hope this helps : )