How can I calculate the difference between two date fields?

  • labman3
    Asked on November 1, 2016 at 6:02 PM

    how can I calculate the time it took to completed a job.

     

    https://www.jotform.com/?formID=62984942194166#

  • Support_Management Jotform Support
    Replied on November 2, 2016 at 2:34 AM

    I checked the Form Calculation widget you added on your form and noticed you mistakenly positioned your minus sign (the operator) at the end of the calculation:

    How can I calculate the difference between two date fields? Image 1 Screenshot 40

    To fix this, just ensure you're subtracting Started FROM Completed like so:

    How can I calculate the difference between two date fields? Image 2 Screenshot 51

    RESULT:

    How can I calculate the difference between two date fields? Image 3 Screenshot 62

    Related guide: How-to-Perform-Calculation-in-the-Form