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.
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?