Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Adding Time to Dates? - Visokio Forums
Formulae: Adding Time to Dates?
  •     Valentina June 18, 2014 3:49AM

    I have a Date column and a column showing the number of days ahead. Eventually I would like to get the Date ahead i.e. if the Date today is 10/06/2014 then in two days it will be 12/06/2014. Please see the example below.

    [Date]           [ DaystoAdd]       [Date ahead]
    10/06/2014           2               12/06/2014
    04/06/2014           5               09/06/2014
    30/05/2014           6               05/06/2014

    Any ideas how to achieve this?

    Thanks in advance‚Äč
  •        daniel June 18, 2014 4:08AM
    DATEADD(date, number, unit)

    Use this function, replace the number bit with the column for days ahead and put "day" for unit.

  •     paola June 18, 2014 1:13PM
    You could also create a dynamic formula, that calculates date which is n number of days from today:

    DATEADD(TODAY(), [DaysToAdd])

    DATEADD formula will assume "day" unit as default, so in this case you could skip that part of syntax.
    forumDateAdd.JPG 64K
This discussion has been closed.
← All Discussions


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership