In this post we will discuss how to use calculated date in infopath 2010 in SharePoint. Also you can check my previous posts on:
Here we will see how the date will come as today's date +10 days. Means suppose Today day is 16th Oct 2013, it should come as 26th Oct 2013.
To do this:
- Add a date picker to the infopath form from the Controls section.
- Right click on the control -> Click on Date Picker Properties...
- This will open the Date Picker Properties window. Click on fx and then in the Insert Formula dialog box, click on Insert Function. Then chose Date category and chose addDays function and click on Ok as shown in the fig below:
Here addDays function took 2 parameter first is date and 2nd parameter is days. so it should like this: addDays(today(),10);
Now change the formula like below
Now the properties window should look like below:
Now click on Apply and Ok, then publish the form. Now the field should populate with today date + 10 days.