In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

undefined

 

thanks

Labels
Top Solution Authors