How do I...?

How can I add # of days to a previously entered date?

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Kristy Heiman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Alex commented  ·   ·  Flag as inappropriate

        Hi Kristy,

        You will want to use a dateadd() function to add units of time to a date field. You'll need to use this in a calculated date or date/time field since the output will also be a date.

        The syntax is: dateadd({Date}, n, "unit") where:

        - {Date} is a Date or Date and Time field
        - n is the number of units to add or subtract
        - unit is one of the following (include the quotation marks in your formula)

        This function can be found in our Knowledge Base here:
        http://help.trackvia.com/knowledgebase/articles/277734-date-functions

        Regards,

        Alex

      Feedback and Knowledge Base