Automating Estimated Completion Dates

[cunninghamsa]

In a form, I have an estimated completion date field which I want to link to the received date and type of inquiry fields. Depending on the "type of inquiry" selected, I want the completion date to be entered automatically based on predetermined service standards, i.e. if "letter of confirmation for insurance" is entered, advisor assigned has 10 days from "received date" to issue a letter to the employee. I have inserted a DateTimePicker in the "estimated date of completion" field now all I need is some pointers as to the best way to accomplish this in a simple way as I am a very junior junior.

 

[Mile-O]

Look up the DateAdd() function in the help files.

 

[geoffcodd]

I use something similar

if([jobtype]) =1 then
duedate = dateadd("d",10,[receiveddate])

elseif([jobtype]) =2 then
duedate = dateadd("d",15,[receiveddate])

and so on

Thanks
Geoff