I'd like to create Scheduled Apex to run overnight. The requirement is to remove sensitive information from a Contact if they have finished attending any courses they are booked onto (i.e. the Course__c.End_Date__c of any course is in the past). Courses is a custom object and has a lookup relationship to the contact. The Contact is likely to have multiple course records that would need to be checked for end date. No field information should be removed if any courses are yet to be taken/finished.
e.g. Make Contact.Field1__c = Null, Contact.Field2__c = Null, Contact.Field3__c = Null when Course__c.End_Date__c (for all the related Course records) < TODAY
If anyone can help that would be fantastic!