Hi - I have a table set up like this:

Contractors (details of people)

Jobs (individual jobs)

Each contractor will have new jobs assigned to them. I would like to know if a job has been assigned more than 5 days ago. What is the best way to do that?

The idea here is that each job has notes on it and if i can see when the job was assigned then I can see if there has been no action taken on it yet and send a reminder. The complexity is that each job could have more than one contractor assigned so I need to know specifically that contractor B has taken no action even though contractors A and C have been making notes.

Thanks!