topic Re: Paginated Report - YEARFRAC similar function in Report Server

Paginated Report - YEARFRAC similar function

JoelN — Tue, 12 Apr 2022 18:54:44 GMT

Hey Guys!

Im trying to accomplish the same fuction of YEARFRAC like excel has but in my paginated report. I tried DATEDIFF expression and got close by not the correct answer. Any help is much appreciated.

Goal: (YEARFRAC Date1, Date2) Ex. YEARFRAC("8/28/2020","12/31/2021")

Answer: 1.34

Attempt:
=CStr(DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate"))\12)&"."& CStr(DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate")) Mod 12)
Attempt Answer: 1.4

Thanks for your help!

Re: Paginated Report - YEARFRAC similar function

FarhanAhmed — Wed, 13 Apr 2022 08:42:24 GMT

Try

= DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate")) / 365

Re: Paginated Report - YEARFRAC similar function

JoelN — Wed, 13 Apr 2022 13:34:31 GMT

FarhanAhmed the solution works! I had to adjust the 365 to 12.
Do you know how to two decimals instead on showing just one?
Thanks!