Custom Date Change - changing Month into "minutes"

Karl_Spratt

Hi Community,

I have a import file and the transaction are coming in YYYY/MM 2020/01, 2020/02 etc.

I need to pull the last 12 months for current month my WF so I doing a date/ time change to split out my date to get 

01-Jan-2020, 01-Feb-2020 etc so I can say pull any transaction in  the last 12 months, I need it to be dynamic. 

But as you can see in the custom split it's putting the "split" Month 01 = Jan in as 01 Minutes. 

Could  anyone advise what I'm doing wrong here.  Adding a sample of the excel imput data we get. 

TIA 

Karl.

Test Data.xlsx

Emil_Kos

Hi,

You need to change your formula to:

yyyy / MM

I have used your month column in order to make it work

Output:

When you write mm it thinks you are referring to minutes not months. MM is the correct format.

There is a great source of information about how to parse date-time using Alteryx:

https://help.alteryx.com/current/designer/datetime-functions

Date time.yxmd