Under Categories in the Insert function dialog box, click Date and Time, and then under Functions, click addDays. For example, you might type txtAdd30Days. A descriptive name makes the form template easier to understand for you or anyone modifying the form template. Tip: It is a good idea to use a name that describes the contents of the field. In the Field name box, type a name for the field, and then click Apply. In your form template, type 30 Days Later in front of the text box control that you just inserted.ĭouble-click the text box that you just inserted. Under Insert controls in the Controls task pane, click Text Box. On the form template, click where you want to insert the text box. Top of Page Step 2: Insert a text box that contains the addDays functionĪfter you add the date picker control and create the formula that uses the today function, you can add a text box to your form template and create a formula that uses the addDays function. Under Categories in the Insert function dialog box, click Date and Time, and then, under Functions, click today. For example, you might type dteToday.Ĭlick Insert Function in the Insert Formula dialog box. In the Field name box, type a name for the field. In your form template, type Today's Date in front of the date picker control that you just inserted.ĭouble-click the date picker control that you just inserted.
Under Insert controls in the Controls task pane, click Date Picker. If the Controls task pane is not visible, click More Controls on the Insert menu, or press ALT+I, C. On the form template, click where you want to insert the data picker. You can then create a formula that uses the today function to display the current date in that control by default. In order to add a set number of days to a date that users enter into a control, you must first add a date picker control to your form template. The date picker control is designed explicitly for storing dates. Top of Page Step 1: Insert a date picker control that displays the current date by default Find links to more information about InfoPath functions in the See also section. You can use the standard XPath 1.0 functions that are included in InfoPath, as well as some InfoPath-specific functions. The values used in the functions are called arguments. The following illustration shows the relationship between a formula and an expression.Ī function is an expression that returns a value based on the results of a calculation. You can think of a formula as a sentence made up of one or more phrases, with each phrase representing one expression in the formula. A formula can contain several expressions. Run a rule based on a value calculated by using a formula.Įach XPath expression that is used in a formula is a combination of values, functions, and operators that evaluates to a single value. Set the default value of a field or control. Formulas can be used to do the following tasks:Ĭalculate 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.ĭisplay the values that users enter into one control in another control. Step 3: Change how the date is displayed in the text boxĪ formula is an XPath expression made up of values, fields or groups, functions, and operators used to calculate and display other values. Step 2: Insert a text box that contains the addDays function Step 1: Insert a date picker control that displays the current date by default
#Formula add days to date how to
This article explains how to add a specific number of days to a date and display the results in a control on a form by using the addDays and today functions. You can use a formula in Microsoft Office InfoPath 2007 to automatically add a specific number of days to a date in a control on your form template.
0 kommentar(er)
