Formula to determine number of days?

[jdmartin]

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

thanks

Jim

[Brendan]

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

[aparna kadam]

Hi,

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

[Brendan]

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