AnsweredAssumed Answered

Find Related Oldest Date Within Specific Date Range

Question asked by on Jan 14, 2016
Latest reply on Feb 4, 2016 by

Hi All:


I'm looking for help creating a calculation field that will be the value of the oldest related record, but restricted to dates within the last five years.


To explain:


We maintain an employee database, which tracks various credentials, clearances, and training sessions. In this case, we have a training which may take place over the course of five years, but must maintain a minimum number of hours in every five year period.


I have a report that will give us the sum of the number of hours within the last five years, but I would also like to include the next date that time will "drop off" from the report, so that we can easily see when someone is coming up on a period of time that they will need to attend retraining.


Does anyone know if/how this is possible?