Code

Re: Calculating date and time differences in infoPath

traveladic — Wed, 08 Feb 2012 00:58:52 GMT

I have a similar situation but I need to account for working hours, for example if the working hours are 7am to 5pm and job started on the 1-Jan-12 at 4pm and it was completed at 2-Jan-12 8am then the total should be 2hrs not 16hr. and as some add fun there are weekends and holidays.

Re: Calculating date and time differences in infoPath

Jimmy — Mon, 17 Nov 2008 04:15:25 GMT

Code like this would do the trick. Of course in actuality you would want to perform error checking first, to make sure that none of the input values is blank, and that endDateCombined occurs after startDateCombined. It would also make sense factor the "xsi:nil" removal code out into a separate method, since it's used three times.

string xsiNamespace = NamespaceManager.LookupNamespace("xsi");
XPathNavigator mdsNav = MainDataSource.CreateNavigator();
mdsNav.MoveToChild("myFields", NamespaceManager.LookupNamespace("my"));

DateTime startDate = mdsNav.SelectSingleNode("my:startDate", NamespaceManager).ValueAsDateTime;
DateTime startTime = mdsNav.SelectSingleNode("my:startTime", NamespaceManager).ValueAsDateTime;
DateTime endDate = mdsNav.SelectSingleNode("my:endDate", NamespaceManager).ValueAsDateTime;
DateTime endTime = mdsNav.SelectSingleNode("my:endTime", NamespaceManager).ValueAsDateTime;
DateTime startDateCombined = startDate.Add(startTime.TimeOfDay);
DateTime endDateCombined = endDate.Add(endTime.TimeOfDay);
TimeSpan diff = endDateCombined.Subtract(startDateCombined);
XPathNavigator nodeNav = mdsNav.SelectSingleNode("my:dayDiff", NamespaceManager);
if (nodeNav.MoveToAttribute("nil", xsiNamespace))
{
     nodeNav.DeleteSelf();
}
nodeNav.SetValue(diff.Days.ToString());
nodeNav = mdsNav.SelectSingleNode("my:hourDiff", NamespaceManager);
if (nodeNav.MoveToAttribute("nil", xsiNamespace))
{
     nodeNav.DeleteSelf();
}
nodeNav.SetValue(diff.Hours.ToString());
nodeNav = mdsNav.SelectSingleNode("my:minuteDiff", NamespaceManager);
if (nodeNav.MoveToAttribute("nil", xsiNamespace))
{
     nodeNav.DeleteSelf();
}
nodeNav.SetValue(diff.Minutes.ToString());

Re: Calculating date and time differences in infoPath

kinecarg — Mon, 17 Nov 2008 02:21:01 GMT

Thank you. I went through the code, and this will be a great help. But the problem I am having is that I need the time between the days calculated, not just the days. For example, the application I am working on has a "Duration of Maintenance" field to calculate possible service outages. If a user enters a start date of 11/18/08 and an end date of 11/19/08 with a start time related to the 11/18/08 date of 11:59 pm and an end time related to the end date of 11/19/08 of 3:00 am, I need the duration of maintenance field to auto fill with a duration of 3 hours and 1 minute. I can calculated the time, but not across days.

Thanks again for your help.

Re: Calculating date and time differences in infoPath

chandrakanth — Sat, 15 Nov 2008 06:22:30 GMT

Hi,

I hope it helps you for solving your issue.

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

Re: Calculating date and time differences in infoPath

sandhyapati — Fri, 14 Nov 2008 03:59:52 GMT

Hi,

Can you go through the below link.I hope it might help you

http://www.bizsupportonline.net/browserforms/calculate-date-difference-infopath-browser-form-c-sharp-code.htm

Calculating date and time differences in infoPath

kinecarg — Thu, 13 Nov 2008 16:36:02 GMT

Hello -

I have a browser based infopath form that I would like to have calculate the time that may or may not cross days. The article posted at:

http://www.bizsupportonline.net/infopath2003/date-time-difference-calculations-vbscript.htm

is exactly what I am looking for, but it is written in VBScript, InfoPath 2003, and I need a browser enabled form, InfoPath 2007. As an example, if the user enters the start date as 11/13/08 with a start time of 11:59 pm

and an end time of 11/14/08 with an end time of 3:00 am, the time calculation should be 3 hours and 1 minute.

Thanks