In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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

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

Hi @usmanbashir 

 

Nice! Thanks you so much.

 

Kamen

Labels
Top Solution Authors