2

I have created the form like below

Star Date : DatePicker

ADd days: Textbox

DueDate: datePicker.

So when the user selects a start date and Add days then the Due date should be displayed based on the calculation of Startdate+add days.

For ex: Is start date is 6/23/2013 and Add days is 7 then due date should be 6/30/2013.

Can you give formule in infopath form or a list.

Thanks, Sandy

1 Answer 1

4

Create a rule on the "Add Days" text box that gets executed when the field is changed.

Let the rule set the value of the DueDate field. Use the function

addDays(Date,Days)

Set the first parameter to the "Start Date" field and the second parameter to the "Add Days" field

enter image description here

4
  • A good answer with a nice, explanatory image deserves an upvote! Commented Jun 23, 2013 at 1:03
  • It works perfectly. thanks .Similarly can i set the time as well?? Commented Jun 23, 2013 at 7:02
  • 1
    @sandy_9866141457, if this solves your question, please mark it as the answer, so that other people can see that there is a solution. As to the time: no, it's not as easy. There is a function called addSeconds(), so you would have to convert any time value into seconds first. That can be a bit tricky for a beginner. You may want to start a new question for that.
    – teylyn
    Commented Jun 23, 2013 at 9:23
  • Thanks i think i need to have 15 score to vote up this answer. @ robert can you vote for this answer on behalf of me Commented Jun 23, 2013 at 9:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.