Date Calculations in InfoPath

re: Date Calculations in InfoPath

Steve — Fri, 16 Sep 2011 23:24:46 GMT

I have an infopath form with a begin date and an end date for reporting. I want records if dates fall into this date range. This comparison works flawlessly until I use a year end date of 12/31/2011. InfoPath seems to get confused at year end for some reason and leaves this record out of the result set. I am using conditional formatting to hide this record on the Infopath form if it does not meet that condition. It's a very simple comparison.

Is dateA >= dateB?

If so, hide this record.

Why does the last day of the year not get included in my results set?

re: Date Calculations in InfoPath

Toby Hosterman - National Pain Institute — Thu, 07 Apr 2011 15:38:20 GMT

I used text parsing to accomplish a datediff between two dates. Here's how I thought it through:

starting with: 2011-04-07T09:43:04

FullTime = substring-after(<dateTime>,"T") = 09:43:04

Hours = substring-before(FullTime,":") = 09

MInutes = substring-before(substring-after(FullTime,":"),":") = 43

(Hours * 60) + Minutes= Allminutes

Seconds = substring-after(substring-after(FullTime,":"),":")

(Allminutes * 60) + seconds = AllSeconds

FinalMinutes = AllSeconds/60

So, the final formula that I pasted into the InfoPath formula box is:

round(((((((substring-before(substring-after(<dateTime>,"T"),":")) * 60) + (substring-before(substring-after(substring-after(<dateTime>,"T"),":"),":"))) * 60) + (substring-after(substring-after(substring-after(<dateTime>,"T"),":"),":"))) / 60) - ((((((substring-before(substring-after(<dateTime>,"T"),":")) * 60) + (substring-before(substring-after(substring-after(<dateTime>,"T"),":"),":"))) * 60) + (substring-after(substring-after(substring-after(<dateTime>,"T"),":"),":"))) / 60))

The <DateTime> references before the - sign were replaced with a reference to the later dateTime field, and the <DateTime> references after the - sign were replaced with a reference to the earlier dateTime field.

In my scenario, I used the form open date/time (populated in a separate field by a rule run on Form Open using the now() function) and I wanted a field to show how long between form open and when the user clicked a button on the page. When the user clicked the button, a rule put now() into a separate field. Then the formula above provided me with an integer of the number of minutes between opening the form and when the user clicked the button.

Hope this helps someone down the line.

re: Date Calculations in InfoPath

Mel Pama — Mon, 21 Mar 2011 22:56:47 GMT

We're still using InfoPath 2003. Can you show me or point me to a link where this is done in javascript. I'm not sure about the XDocument.SelectSingleNode or if it's XDocument::SelectSingleNode.

Please replyh to mel.pama@renesas.com

re: Date Calculations in InfoPath

OPT — Wed, 23 Feb 2011 16:22:46 GMT

Are you kidding me!!!!!! Why did the "TEAM" take out the AddDAte function......PUT IT BACK...how stupid was that.......

Date Calculations | keyongtech

Date Calculations | keyongtech — Thu, 22 Jan 2009 07:52:35 GMT

PingBack from http://www.keyongtech.com/1238824-date-calculations

Berechnung von Zeit | hilpers

Berechnung von Zeit | hilpers — Tue, 20 Jan 2009 18:07:30 GMT

PingBack from http://www.hilpers.com/1085772-berechnung-von-zeit

re: Date Calculations in InfoPath

Elfoamerican — Mon, 12 Jan 2009 17:07:03 GMT

It's posible to calculate date difference with rules only.

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

the rasx() context » Blog Archive » SonghaySystem.com Articles Never Written

the rasx() context » Blog Archive » SonghaySystem.com Articles Never Written — Tue, 01 May 2007 20:25:54 GMT

PingBack from http://www.kintespace.com/rasxlog/?p=621