Free Trial

Alteryx Designer Desktop Discussions

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

Combine two Date fields together D/M and Y

alphabex18
8 - Asteroid

I have two fields, one is MM/DD and the other is YYYY. I want to combine both into one with the end result being YYYY-MM-YY. Thank you so much

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

suppose field1 is mm/dd (example:  11/22) and field2 is yyyy (example 2017)

 

[Field2] + "-" + Replace([Field1],"/",'-')

That's the answer (I hope).

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors