How to calculate the day count from two date fields?

  • Profile Image
    basedave
    Asked on April 25, 2016 at 06:17 AM

    I intend creating a leave form that automatically insert number of days after choosing from the calendar from and to date. just like an auto calculating system.E.g. from 01/03/2016 to 05/03/2016 to give us 5days automatically.

    Your reply will be highly appreciated.

     

    Thanks. 

  • Profile Image
    ashwin_d
    Answered on April 25, 2016 at 08:17 AM

    Hello basedave,

    You can take advantage of our "Dates difference" widget and see if that fits into your requirement. It will automatically give you the day count between two dates. Please check the screenshot below:

     

    Please be noted that you can also add two date fields and then add a "Form Calculation" widget to calculate the date difference between the date fields. Please check the screenshot below:

     

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!