AnsweredAssumed Answered

Script to find data from date fields.

Question asked by danlee on Jul 24, 2013
Latest reply on Jul 24, 2013 by danlee

Title

Script to find data from date fields.

Post

     I have table MeasurementData with a date field BodyAgeDate.  How can I set this up finding data from this field of first date and most recent date.  Example:  In MeasurementData table I have a field named BodyAgeDate, with another field in it titled Weight.  I want to set up a calculation field Beginning Weight and Current Weight where it would take the data from field Weight and populate the Beginning Weight and Current Weight.

     Example:

     BodyAgeDate 7/12/2013; Weight 233 --> This would be Beginning Weight

     BodyAgeDate 8/12/2013; Weight 200 ---> If for some reason 7/12/2013 record was deleted or changed to later date, 8/19/2013, then this would be Beginning Weight

     BodyAgeDate 8/22/2013; Weight 220

     BodyAgeDate 9/2/2013; Weight 190 ---> This is the most current/recent weight

     So for Beginning Weight field it would calculate to be 233

     Current Weight field it would calculate to be 190

MeasurementData table

      

Outcomes