I have a quality corrective action FM database which involves entering a complaint and then an assignee to correct that complaint.
Before this complaint is sent to the assignee, it requires a response due date (Due Date) that I want based on a response time drop down list, which will always be different pending the severity of the complaint.
So if the response required to the complaint is "Urgent" it then adds 5 days to the entry date (Entry Date) value in the Due Date field. If the response is "Routine" then it adds 18 days to the entry date and so on.
I have tried writing this with the Case function but I think I am taking the wrong approach??
Any help with a function or pointing me to another discussion would greatly be appreciated!