Please note that from Infiniti v9 onwards the User Prompt
question type has been renamed Text Field
Sometimes it is necessary to use a formula to calculate a value that can be used to determine if a particular piece of content should be included in the document.
In the formula below the RangeIndex() formula is used to place people into three different categories based on their age, the [Q4] reference is to a date of birth, possibly from a text field or data source.
RangeIndex(DateDiff(0,[q4], Today(), 1, 1), 0, 18, 55)
The formula will return 0 for child (0-18 years), 1 for adult (18-55 years) and 2 for retired (55+ years). This formula when coupled with an auto logic question is a straightforward way to include content based on age. In the screen shot below the RangeIndex() formula answer rules determine which content is included.
range index category formulae decide decision autologic