Alteryx Designer Desktop Discussions

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

Combining dates

Riot
8 - Asteroid

So I am have broken down a numaric date, but I would like to convert the numerical month and year into a variable that I can enter into a decision tree or forrest model. I have been messing with formula for awhile now but I cant seem to get it. Would would be the best way to do it and what would a good field variable be?  Thank you. 

10 REPLIES 10
s_pichaipillai
12 - Quasar

Riot,

you can try this as well with your sample data :-)

 

this will convert your dates into DDMMYYYY,Month,Year and Time Formats :)

like below screenshot

riot.PNG

 

thanks

Labels