6 Replies Latest reply on Mar 11, 2015 6:50 AM by Shawn Wallwork

    Calculate no of days using datediff between last amount  date and previous amount date

    Jagjit Singh

      Hi All,

       

      In the attached workbook I like to calculate the day difference between last Rent change and previous Rent change. After that I like to only show prop_code for which the date difference in days is < 365 days.

       

       

       

      Thanks

      Jagjit