Controls

Re: Is there a way I can calculate the number of Days?

Jimmy — Wed, 13 Jul 2011 13:40:05 GMT

To which link are you referring? The swits.net link that goes to a generic domain parking page, as swits.net has apparently closed down? Alec's link does have a solution to this question and none of the things you describe.

Re: Is there a way I can calculate the number of Days?

Donna Graham — Wed, 13 Jul 2011 12:40:32 GMT

This link sent me to a site with a list of sites for paid training and consulting it didn't have this answer don't waste your time going.

Re: Is there a way I can calculate the number of Days?

Alec Pojidaev — Tue, 30 Dec 2008 19:32:33 GMT

Here is compact codeless method:

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Re: Is there a way I can calculate the number of Days?

Jameski — Wed, 30 Apr 2008 21:19:37 GMT

I also get a zero, can you possible post a link to the working form.

Re: Is there a way I can calculate the number of Days?

edwardvn — Tue, 29 Apr 2008 19:58:39 GMT

please does any body know where i can get this working form?

Re: Is there a way I can calculate the number of Days?

edwardvn — Mon, 28 Apr 2008 08:30:55 GMT

You dont possibly have this in a form that i can use do you, i entered all the stuff like it says, but i just get a zero.

I would very much appreciate you help

Kind Regards

Edward

Re: Is there a way I can calculate the number of Days?

edwardvn — Fri, 25 Apr 2008 14:40:40 GMT

This is exactly what i want but the value returned is allways 0, i have no idea what i have done wrong, you dont happen to have a working example form with it in do you. I am desperate and dont know what to do.

Kind Regards

Edward

Re: Is there a way I can calculate the number of Days?

norale — Thu, 15 Nov 2007 03:06:33 GMT

Hi, just want to share a solution to calculate days for different dates using rules.

http://enterprise-solutions.swits.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm

Thanks.

Re: Is there a way I can calculate the number of Days?

Kalyan Gaddam — Wed, 22 Aug 2007 15:23:02 GMT

Hello

Read the link below

http://enterprise-solutions.swits.net/infopath2003/article.php?t=datediff-vbscript-infopath&c=infopath2003

also there are many articles under Date and Time header in the same site which can be of some help

Re: Is there a way I can calculate the number of Days?

Greg Collins — Wed, 18 Jul 2007 20:29:01 GMT

I was thinking more along the lines of:

DateTime date1 = thisXDocument.DOM.selectSingleNode("my:Date1");
DateTime date2 = thisXDocument.DOM.selectSingleNode("my:Date2");

TimeSpan diff = date2.Subtract(date1);

int days = diff.Days; // Whole days (i.e. '5').
double fdays = diff.TotalDays // Whole + fractional days (i.e. '5.23412').

Re: Is there a way I can calculate the number of Days?

Curious — Tue, 17 Jul 2007 11:45:29 GMT

though this code may not work correct but just a quick idea

int daysNumber = Convert.ToInt32(d1.Value.Day - d2.Value.Day); // d1 and d2 are the datetime picker controls...

Re: Is there a way I can calculate the number of Days?

Greg Collins — Tue, 03 Jul 2007 20:40:32 GMT

Look out on the MSDN.com site at the methods for the DateTime object. You should find everything you need there.

Re: Is there a way I can calculate the number of Days?

mrssteelhead — Mon, 02 Jul 2007 17:29:37 GMT

Greg,

Thanks for the quick reply, you wouldn't happen to have an example of the code, or can you point me in the direction of someplace I can look at an example?

Re: Is there a way I can calculate the number of Days?

Greg Collins — Mon, 02 Jul 2007 16:42:26 GMT

InfoPath 2007 does allow some date math... However, the easiest way is to use managed code to read the two dates and use the wonderful date functions available in C# and VB.NET to do what you want.

Is there a way I can calculate the number of Days?

mrssteelhead — Mon, 02 Jul 2007 14:57:47 GMT

I have 2 date picker controls in my InfoPath 2007 form - a start date and an end date, I would like to be able to get the number of days the range expands, is there a way I can do this?

MrsSteelhead