Hello I work for a nursing agency and I was tasked with creating a way for my boss to keep track of the certification that the nurses must have in order to work. There are a total of 15 certifications and four nurses. Each certification expires in either a year or a half of a year. Each certification was received at a different time. For example, employee A received certification XYZ 12-1-17 and employee B received it 11-30-17. My boss would like to get an email reminder when those certifications are within 45 days of expiration. Any ideas on how to set up the database to do this?
Bookmarks