Amal Nagm

• Calculate mathematical values from values that you specify when designing the form template or values that users enter into controls when they fill out forms based on your form template..
• Display specific dates and times.
• Display the values that users enter into one control in another control.
• Set the default value of a field or control.
• Run a rule based on a value calculated by using a formula.

Step 1: Insert a date picker control that displays the current date by default

1. On the form template, click where you want to insert the data picker.
2. If the Controls task pane is not visible, click More Controls on the Insert menu, or press ALT+I, C.
3. Under Insert controls in the Controls task pane, click Date Picker.
4. In your form template, type Today's Date in front of the date picker control that you just inserted.
5. Double-click the date picker control that you just inserted.
6. Click the Data tab.
7. In the Field name box, type a name for the field. Tip It is a good idea to use a name that describes the contents of the field. A descriptive name makes the form template easier to understand for you or anyone modifying the form template. For example, you might type dteToday.
   
8. Click Apply.
9. Click Insert Formula .
10. Click Insert Function in the Insert Formula dialog box.
11. Under Categories in the Insert function dialog box, click Date and Time, and then, under Functions, click today.

Step 2: Insert a text box that contains the addDays function

1. On the form template, click where you want to insert the text box.
2. If the Controls task pane is not visible, click More Controls on the Insert menu, or press ALT+I, C.
3. Under Insert controls in the Controls task pane, click Text Box.
4. In your form template, type 30 Days Later in front of the text box control that you just inserted.
5. Double-click the text box that you just inserted.
6. Click the Data tab.
7. In the Field name box, type a name for the field, and then click Apply. Tip It is a good idea to use a name that describes the contents of the field. A descriptive name makes the form template easier to understand for you or anyone modifying the form template. For example, you might type txtAdd30Days.
   
8. Click Insert Formula .
9. Click Insert Function in the Insert Formula dialog box.
10. Under Categories in the Insert function dialog box, click Date and Time, and then under Functions, click addDays.
11. Click OK.
12. In the Formula box, double-click the first instance of double click to insert field.
13. In the Select a Field or Group dialog box, click dteToday, and then click OK.
14. Click the second instance of double click to insert field, press DELETE, and then type the number of days that you want to add to the current date. For example, if you wanted to add 30 days to today's date, you would type 30.
15. To test that your formula is entered correctly, click Verify Formula. My formula contains errors
    Click Show Details in the Microsoft Office InfoPath dialog box to see the errors in the formula. The following are some suggestions for resolving these errors:
    • If you are using a function in your formula, verify that you are using the correct arguments for the function. Some functions require fields or groups while other functions require specified values as arguments. Find links to more information about functions in the See also section.
    • Delete and retype your formula to make sure that it is correctly typed.

Step 3: Change how the date is displayed in the text box

1. In the form template, double-click the text box.
2. Click the Data tab.
3. In the Data Type list, click Date (date), and then click Format.
4. In the Display the date like this list, click the display style that you want. Note Display styles that have an asterisk will update based on the user's system settings.
   
5. To test your changes, click Preview on the Standard toolbar, or press CTRL+SHIFT+B.