InfoPath Dev

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

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.

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?

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

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...

 

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').

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

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.

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

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

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

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

Here is compact codeless method:

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

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.

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.