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.
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