Duration function

This function returns the value of the Duration field from the Main tab of the Estimate Information window.

Syntax

DURATION

Example:

DURATION * 30
This converts a duration given in months to days when you take off items that are calculated on a daily basis.

Tip: Sage Estimating (SQL) cannot determine which estimate contains the duration when you test a formula by starting from the Data tab (or Database menu, in classic view). In that case, the formula assumes the value is 1.