How do I...?

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

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Kristy Heiman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
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