AnsweredAssumed Answered

Get data from previous month

Question asked by danlee on Jan 25, 2015
Latest reply on Jan 25, 2015 by danlee


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