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

Calculate years and months in given Datedif

mlim0806
7 - Meteor

Hello Community, 

 

I have a newly created column "Time in Position" that is using datetimediff to calculate months inbetween date field and today's date. How would I change this to show years and months with labels included?

 

Example: 

 

Output = 17

Desired Output= 1 year, 5 months

 

mlim0806_0-1661796025616.png

 

3 REPLIES 3
chukleswk
11 - Bolide

@mlim0806 I have updated my solution and attached a flow that can help you.

Capture.PNG

binuacs
20 - Arcturus

@mlim0806 One way of doing this 

binuacs_0-1661810419460.png

 

mlim0806
7 - Meteor

Thank you, both soluations worked!  

Labels