Adjust the number of days added (plus or minus) and the date format as needed.Delete the square brackets from around the Add Days formula that you just pasted, so that the only square brackets are at the beginning and end of the combined formula.Highlight Today’s Date in the Date Format formula, then press CTRL+V to paste the Add Days formula in place of the highlighted text.Select the entire Add Days formula - and press CTRL+X to cut it.Double-click the Add Days formula to add it to the text field after the Date Format formula.Enter a name for the new custom formula in the Description field.In the Custom Formula dialog, double-click the Date Format formula to add it to the text field.For example, if you want to output a future date and specify the date format, you can combine the Add Days and Date Format formulas as follows. You can combine formulas by inserting one into another and removing extraneous brackets. TruncateĬonverts a decimal to an integer by dropping the digits after the decimal point instead of rounding. Substitute an application data item or expression for "12.3456." The value after the comma is the number of decimal places you want used for the rounded result. RoundĮnables you to round numbers to a specified number of decimal places. If a calculated amount results in a negative number, the Abs formula drops the minus sign. Outputs the absolute value, which is always positive. Note: You can also create IF expressions using the IF Expression tab at the bottom of the Custom Formula dialog. To create the condition, you can use comparison operators such as greater than (>), less than or equal to (), and so on. Substitute a condition for "formula," such as a dollar value being greater than or equal to a specified amount, and substitute static values, application data items, or expressions for "true" and "false." The true value will print when the condition is met, and the false value will print otherwise. Expressions IFĮnables you to create a condition that outputs different results based on whether the condition is met. For instance, if you wanted to calculate a client’s age you could compare the “Individual Date of Birth” variable with the “Today’s Date” variable. Place the earliest date first and latest date last. This Formula Variable can be used to “count” the span between two date variables. In the default formula, shown above, a sample date would be displayed as January 1, 2009. The Date Format formula enables you to specify the format for the date used in the formula. The Add Months formula is similar to Add Days but adds months rather than days. You can use a negative number to output an earlier date. The default formula provided by the application, shown above, would output tomorrow’s date (today’s date + 1 day). The number after the comma determines the number of days away from the specified date that the formula should display. You can substitute another date variable for "Today’s Date" by inserting it from the available application data items. The Add Days formula enables you to output a date that is a specified number of days away from another date, such as today’s date. The formulas available include Dates, Expressions, and Math formulas.
The Custom Formula dialog includes, in the right pane, a collection of system formulas that address specific situations. Note: For information on formatting text, see the appropriate sections of the topics Modifying custom formats and Custom formats toolbars. The OutputValue Formula dialog opens, where you can make changes to the text and/or formula, as described in the other sections of this topic. To modify a formula or text item on a custom format, double-click that item in the formatter. Modify the formula item as needed, just as you would for any other item, such as a text box.Click and drag the formula you created into the formula designer, and drop it where you want it to appear.In the Fields pane, click the Expand button to expand the Custom Formula item.Once you have created a custom formula, it is quite simple to add it to your custom format. The formula is saved, and appears in the Fields pane under the Custom Formula item.Īdding a custom formula to a custom format When the formula is complete, click OK.
You can further refine the formula manually by editing it directly in the text entry field. Note that you can also enter parts of the formula manually in the text entry field.