Newbie Questions

Re: Two Date\Time Text Box Field Calculation for Minutes Difference

Levetts — Fri, 08 Dec 2017 16:27:27 GMT

Does this work with 2007 filler forms? I was looking into this but didn't understand where to put the 4 condition.

Re: Two Date\Time Text Box Field Calculation for Minutes Difference

The Noob — Fri, 23 Sep 2016 17:24:57 GMT

Thank you Hilary! Appreciate the direction to the site. I'll soak it up and give it a go

Re: Two Date\Time Text Box Field Calculation for Minutes Difference

Hilary Stoupa — Fri, 23 Sep 2016 17:16:40 GMT

Unfortunately, DateDiff is not a built in InfoPath function - it is from an add in for InfoPath (built by the company I work for) called qRules. There are formulas out there that will allow you to do this without code or third party add ins - but they are pretty complex. http://www.bizsupportonline.net/infopath2003/time-calculations-infopath-using-rules.htm has one sample.

Two Date\Time Text Box Field Calculation for Minutes Difference

The Noob — Fri, 23 Sep 2016 16:34:19 GMT

Hello,

I am having some dificulty getting the below formula to work and display the minutes difference between two date\time text box fields. Please help :)

concat(" DateDiff /date1=", /my:myFields/my:KeyEvents/my:OptBusinessImpactStarted/my:BusinessImpactStarted, " /date2=", /my:myFields/my:KeyEvents/my:OptRestored/my:Restored, " /component=totalminutes")