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

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
chuckleswk
11 - Bolide

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

Capture.PNG

 

binuacs
21 - Polaris

@mlim0806 One way of doing this 

binuacs_0-1661810419460.png

 

mlim0806
7 - Meteor

Thank you, both soluations worked!  

Labels
Top Solution Authors