3 Replies Latest reply on Jan 25, 2015 11:36 AM by danlee

    Get data from previous month



      Get data from previous month


      I have two fields that I have to get a calculation from previous month and two months prior.  I have a date range field, BodyAgeDate and another field, BodyWeight.  So I need to create another calculation field, CompareDates, that calculates the 2 months.  So it would look like this:

      Previous Month

      BodyAgeDate 12/31/14

      Body Weight 135

      2 Months Ago

      BodyAgeDate 11/30/14

      Body Weight 145

      Compare Dates

      Result should be 135-145 = -10