comparing multiple records

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I am trying to look at a group of records for an individual and return when their next recertification is due. Currently I have records for each recertification and when the next is due. However, when they are recertified it may be for more than one type and the expiration dates may not all be the same. What I would like to do is look back through their records and determine when the next certification is due and return just that due date, so I can see a list of all employees and when their next certification is due.
Photo of Dante Tognoli

Dante Tognoli

  • 406 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Assuming that the certification records have a field for [Date Completed], then it would just be a summary field on a relationship where 1 employee has many certifications, and it would be a summary minimum of the Certification Due Date where the [Date Completed] is blank.
Photo of Dante Tognoli

Dante Tognoli

  • 406 Points 250 badge 2x thumb
I'll give that a shot, Thanks.