Re: How To Calculate Number of Days Between Two Dates

Clay Fox — Sat, 23 Jun 2007 20:56:45 GMT

This is fairly common and too bad that InfoPath has not put a function in to support this so you have to use script.

There are a couple different approaches but I have used a pretty simple vbscript using the DateDiff function. Here is a pretty good thread. http://www.infopathdev.com/forums/thread/9236.aspx

First if you have not used code yet is the syntax of referencing your fields and the second is using the Datediff function. You should be able to search on both and get the answers you need.

Here is a sample I had in the onload event to calculate 90 days in advance from today to show imminent items.

Pasting did not work so well so i have attached it.

How To Calculate Number of Days Between Two Dates

ultragc — Thu, 21 Jun 2007 18:41:11 GMT

I am trying to calculate the number of work days between to days. Has anyone done something similar or have any suggestions on how I might be able to accomplish this? Basically, I am testing a vacation request from that has a "from" and a "to" field. A third field, called "days", be populated with the number of days once both days are entered.

Thanks in advance.

General

Re: How To Calculate Number of Days Between Two Dates

How To Calculate Number of Days Between Two Dates