Date arithmetic

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Date arithmetic

Viewing 1 reply thread
  • Author
    Posts
  • November 13, 2018 at 8:43 AM #31759

    al m
    Participant

    I programmed a calculation- ([Date begin]+13*24*60*60) To calculate 13 day from a specified date but date 11/1/18 resulted in 11/13/18
    Not the correct answer which is 11/14.

    Is there some method to us to increase the reliability of the calculation.

    November 13, 2018 at 6:04 PM #31764

    Brendan
    Keymaster

    Hello Al,

    You’ll want to use the DATEADD() function to accomplish this

    DATEADD(Date;Y;M;W;D;H;M;S)

    Y = Years, M = Months, W = Weeks, D = Days, H = Hours, M = Minutes, S = Seconds.

    Set the formula to return a Date Result Type.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.