AnsweredAssumed Answered

Find Related Oldest Date Within Specific Date Range

Question asked by nbray@brandywinebus.com on Jan 14, 2016
Latest reply on Feb 4, 2016 by nbray@brandywinebus.com

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?

 

Thanks!

 

Nate

Outcomes