Forum Discussion

JoelN's avatar
JoelN
Icon for Helper I rankHelper I
4 years ago
Solved

Paginated Report - YEARFRAC similar function

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 appr...
Paginated Report - YEARFRAC or DATEDIFF Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Try 

    = DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate")) / 365
  • JoelN's avatar
    JoelN
    4 years ago

    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!

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
4 years ago

Try 

= DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate")) / 365
JoelN's avatar
JoelN
Icon for Helper I rankHelper I
4 years ago

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!