Calculate the days difference between 2 dates

Question

Hi expert,

i created a form from InfoPath 2013:

        Date From   [Field1:Date Picker]

        Date To       [Field2: Date Picker]

        Total No. of Days [Field3: Textbox]

i want to accomplish:

       1. Once i entered the date from Field1 and Field2,  it will calculate the the total number of days then displayed it in Field3

       2. It will show an error when the Date To is less than the Date From

Hope anyone could help me. Thanks in advance

Answer 1

Hi,

Here is a step by step demo which is verified in my environment would be helpful to you:

http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm

Best regards,

Patrick

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].

Answer 2

Hi Patrick,

Thank you for your reply.

when i click the link it goes back to this page. Can you please check again.

Thanks

Answer 3

Hi,

I have updated the hyperlink in my previous reply, please check.

Best regards,

Patrick

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].