Alteryx Designer Discussions

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

Calculate years and months in given Datedif

mlim0806
5 - Atom

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
17 - Castor

@mlim0806 One way of doing this 

binuacs_0-1661810419460.png

 

mlim0806
5 - Atom

Thank you, both soluations worked!  

Labels