Forum Discussion

JoelN's avatar
JoelN
Helper 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
Community Champion
4 years ago

Try 

= DATEDIFF("m",Fields!Acquisition_Close_Date.Value,First(Fields!MaxReturn.Value, "MaxReturnDate")) / 365
  • JoelN's avatar
    JoelN
    Helper 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!