Hi,

I have a module called 'Illnessregistrations' which contains illnessregistrations of employees. When a new record (so new illnessregistration from an employee) is made in this module, I want a function to search if that employee has already another record in the module with a creation date between now and 4 weeks ago. 

If yes, a field called 'Last 4 weeks ill' should get the value 'Yes'. The default value of this field is 'No'.

The field 'Employee' is a look up field to the module 'Employees'

Could someone help me with this code?