Alteryx Designer Desktop Discussions

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

Compute in Years with Decimal

KamenRider
10 - Fireball

Hi

 

I have these dates in date data type format wherein I am trying to compute the maturity date in years with decimal like below data. The formula I use was DATETIMEDIFF(Maturity date, Effective date, "years") however, the only problem is that i am getting a whole number as results. Can someone help me how to add decimal points in the maturity column? 

 

matdate.JPG

Hoping to hear from anyone

 

Thanks,

Kamen

2 REPLIES 2
usmanbashir
11 - Bolide

@KamenRider - please see attached workflow - Hope this helps!

 

 

KamenRider
10 - Fireball

Hi @usmanbashir 

 

Nice! Thanks you so much.

 

Kamen

Labels