Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors