Using Dates in Formulas for Smart Forms

Using Dates in Formulas for Smart Forms

Some Smart forms require formulas to reference dates, either manually inputted dates, or reading from the Gantt. In this example group we have some date functions at play with some fields not shown but are required for the calculations. 

• “Today” is the current date (it does reply on the scheduled job performing a full recalculation every day)
• “Tomorrow” adds a day to the current date
• “Days Previous” is taken off the current date to give “New Date”
• “Diff” is the difference between Date 1 and Date 2

We can add days (positive and negative) to dates and calculate the differences between dates.

This is done via the following:

• A new field type – Numeric Function For Dates
• System variable – TODAY
• Adding a suffix of “N” to Date Function fields (and the new TODAY variable) to return a decimal representation of a date.
• Adding a suffix of “D” to the Numeric Function For Dates fields to return a date from a decimal.

The above group has the following fields:

Help with Formulas

There are tooltips within the formulas page which can assist with formatting.  Hover over any of the 'Show help for' options on the right-hand side.