How to calculate dates difference?

  • Profile Image
    Asked on March 21, 2018 at 07:19 AM

    Hi Evereyone 

    For the life of me i cant get this done to display amount of days between arival and departure dates

     what i need is a client to input arrival and departure dates and i want that to be multiplied by amount of people and then the amount per day ,giving him a total for his stay

    Thanks ,the closest i got was

  • Profile Image
    Answered on March 21, 2018 at 10:17 AM

    You can achieve this using the Form Calculation Widget.
    Help Article: How to Perform Form Calculation Using a Widget

    I have created a DEMO form for you.

    You can calculate the dates difference by subtracting the fields in the Form Calculation Widget.


    For the amount per day per person, you can use a number field, set a default value, and make it read-only. This field is not really needed but it is easier to change the calculation if this amount ever changes.


    You also need a field for the number of people. Then, you multiply all of them using the Form Calculation Widget again.


    This can, of course, be done without the extra calculation of the dates difference in another field and without the amount per day field.


    Feel free to clone my form and adjust it to your needs.