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?
Hoping to hear from anyone
Thanks,
Kamen
Solved! Go to Solution.