Can I calculate the days between two dates?

  • Profile Image
    Asked on May 18, 2015 at 09:43 AM

    Can I calculate the days between two dates?

    This is a re-post of a comment on Form Calculation - Math Function Reference

  • Profile Image
    Answered on May 18, 2015 at 11:04 AM

    Yes, you can perform calculation in the dates. I created a demo form that shows the start date, the end date, and the total number of days. Here are the steps that I did to make this demo form.

    1. I created 2 DateTime fields.

    2. I also created a normal text box field where the result of the calculation will show.

    3. After that, I used the condition "Update a Form Field Value".

    4. The condition looks like this:

    The condition (If End Date is Filled) is configured like this so that the (Total Days) field will not show any value  until the data is completed. Because, if you put a value on the Start date, it will immediately perform calculation even if there is no End date.

    The formula shows End date - Start date, because it will be a negative value if it is the other way around.

    Let us know if you need any help. Thank you.

  • Profile Image
    Answered on May 30, 2015 at 05:27 AM

    If in this issue I want to fix the end date as 01/04/2015.

    then please tell how can I fix this date in end date.

    and i want to calculate age in years.

  • Profile Image
    Answered on May 30, 2015 at 07:02 AM


    You need to open a new thread next time so that we can assist you properly. I created a thread for you,  this is the URL of the new thread:

    Thank you for understanding.