Staff Clearances Due Date Notification

I am trying to set up a database to keep track of staff clearances. I have fields for each clearance with the date the staff got the clearance. Is there a way to get notifications when a staff’s clearance is going to expire? For example, the FBI clearance is valid for 2 years from the date it is run. How would I get a notification when 2 years is up and they would need to renew the clearance?

Any help would be appreciated!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.