Skip to main content
Question

Cannot calculate end date

  • Jun 26, 2019 5:09 PM UTC
  • 0 replies
  • 42 views
Forum|alt.badge.img+11
I am creating a table for a construction schedule.

I have several fields but some of them are giving me trouble.  I have:
Start Date - Work Date Type
Duration - Duration Type
End Date - Formula Work Date Type

In the End Date I am using the End Date Formula builder.  I set Start Date for my start date.  For the timespan question Duration is not showing in the dropdown.  Any ideas why?
    This topic has been closed for replies.

    • XavierFan
    • Observing
    • Jun 26, 2019 5:56 PM UTC
    The documentation doesn't make this clear, but [Duration] should actually be a Numeric field (for the number of days).

    So if you changed your [Duration] field to type Numeric, or created a new Numeric field to use - then the Numeric field would show up in the dropdown for the Formula builder for the End Date.
    Terms & ConditionsAccessibility statement