Options

• Title: Provide a title or question to the date question by setting the title type and toggle “Title is visible?” to change the visibility on the calculator.
• Add tooltip: Toggle this option if you want to add a tooltip to the question.
• Description: You can add a description under the title or question. You can use markdown markups to format.
• Default value: Toggle to add a default value. It will be “today’s” date.
• Is this question required?: Toggle if you want to make it mandatory to answer the date question.
• Show/Hide Logic: Toggle this to control if this question is shown or hidden under certain circumstances.
• Visibility formula: If the result of the formula is TRUE or a number above 0. The question is visible. If the result is FALSE or 0, it’s hidden.

Usage in calculations

• By default, it returns the date.
• You can calculate with a date (e.g., when you want to subtract or add a certain amount of days from a date) by turning it into its numerical equivalent. You can do this with QA{spreadsheetTime}.
• You can return on a formula: QA{isWeekend} which returns 1 if true, 0 if false; and QA{differenceToToday} which returns the amount of days difference to today.
• You can include this element in different functions as DAYS, YEAR, and TODAY.
• You can combine different functions and nested IF’s to create different results according to dates or number of days after the day selected by the customer. i.e., Increment pricing on earlier dates (e.g., within 5 days) and later dates (e.g., after 15 days) lower price.

Example calculator