Formula to determine number of days?

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Formula to determine number of days?

Viewing 3 reply threads
  • Author
    Posts
  • December 12, 2011 at 3:17 AM #3555

    jdmartin
    Participant

    Is there a formula that can be used to determine the numbers of days between two dates?

    thanks

    Jim

    December 12, 2011 at 8:39 AM #4966

    Brendan
    Keymaster

    Hello Jim,

    When you do a date calculation in Tap Forms (e.g. End Date – Start Date), Tap Forms will generate the result in terms of the number of seconds between those two dates. So all you need to do to calculate the number of days between those two dates is to use this formula:

    Total Days = ([End date] – [Start Date]) / 60 / 60 / 24

    Hope that helps!

    Brendan

    November 7, 2016 at 5:02 AM #20336

    aparna kadam
    Participant

    Hi,

    I tried using the formula to determine total number of days but am not getting the result. What wrong am I doing?

    November 7, 2016 at 12:48 PM #20337

    Brendan
    Keymaster

    Hi Aparna,

    I replied to you via email, but perhaps the problem may be that you’ve put the “Total Days =” part into the formula too. If so, remove it.

    The formula should just be:

    ([End date] – [Start Date]) / 60 / 60 / 24

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.