Calculate a Date based on a start date and duration

  • jpechmajou
    Asked on March 14, 2024 at 6:19 AM

    I have a date entry field in my form called Close of Escrow

    I have a duration in my form in days

    I would like to calculate a date in the future = Close of Escrow + duration

    How to do this?

  • Danilo JotForm Support
    Replied on March 14, 2024 at 7:20 AM

    Hi Jonathan,

    Thanks for reaching out to Jotform Support. I am not sure if I got your concern correctly. Are you referring to calculating the days between the Start Date and End days or duration? If yes, you can use the Date field element and set up a default date to your End date field. Let me show you how:

    • In Form Builder, go to your My Forms page.
    • On the left side of the page, click on Create Form.
    • Click on the Add Form Element menu on the left side of the page.
    • Under the Basic tab, scroll down the list, choose the Date field, and then drag and drop them onto your form.

    Calculate a Date based on a start date and duration Image 1 Screenshot 60

    Then, you need to set a default date in End Date/Duration

    Calculate a Date based on a start date and duration Image 2 Screenshot 71

    You must set the End date duration to read only so the user can't able to change it.

    Calculate a Date based on a start date and duration Image 3 Screenshot 82

    Then, you need to add Form Calculation widgets to calculate the date range:

    • In Form Builder, click on the Add Form Element menu on the left side of the page.
    • Under the Widgets tab, search for the Form Calculation widget and add it to your form.
    • In the Widget Settings window that opens up, you the format I made in my demo form. 

    Calculate a Date based on a start date and duration Image 4 Screenshot 93

    Here's the result of my demo form:

    Calculate a Date based on a start date and duration Image 5 Screenshot 104 Give it a try and let us know how it goes.

  • jpechmajou
    Replied on March 28, 2024 at 10:22 AM

    Hello -

    I have a start Date

    I have a duration

    I want to calculate an End Date = Start Date + Duration.

    How could I do this?

  • Kim JotForm Support
    Replied on March 28, 2024 at 10:29 AM

    Hi Jonathan,

    Thanks for getting back to us. So, in other words, you're trying to get the end date by adding the Duration to your start date. If so, you can try this condition:

    Calculate a Date based on a start date and duration Image 1 Screenshot 20
    Here's my demo form that you can try.

    If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?