Two Date\Time Text Box Field Calculation for Minutes Difference - InfoPath Dev
in

InfoPath Dev

Two Date\Time Text Box Field Calculation for Minutes Difference

Last post 12-08-2017 08:27 AM by Levetts. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 09-23-2016 09:34 AM

    Two Date\Time Text Box Field Calculation for Minutes Difference

     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") 

  • 09-23-2016 10:16 AM In reply to

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

     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.

    Hilary Stoupa

  • 09-23-2016 10:24 AM In reply to

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

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

  • 12-08-2017 08:27 AM In reply to

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

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

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.