4 Replies Latest reply on Mar 10, 2017 8:17 AM by mikebeargie

    Help with a Due Date Case function

    milefaker76

      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!

       

      MileFaker