Formula output variations

In this section, you will learn how to use properties to work with formula inputs to make the formula more dynamic and automatic when changing database information.

As previously mentioned, you can use property information in place of arguments in a formula, allowing you to have more dynamic formulas as shown in Figure 9.2.

Creating a Due Date formula

The Due Date formula looks at the Start Date property for the date argument, finding out the number argument from the Number property, then finding out the time argument from the Time property and using that information in the dateAdd function to create a due date. This means that by changing the Start Date, Number, or Time property information, the formula will automatically change.

Figure 9.2 – A Due Date formula using other properties in place of the formula arguments

Note

The dateAdd function uses a text string in the Time argument, which means the letters in the...