AnsweredAssumed Answered

Help with a Due Date Case function

Question asked by milefaker76 on Mar 10, 2017
Latest reply on Mar 10, 2017 by mikebeargie

Hello All!


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!