General

Re: substract two dates to have days

walspec — Mon, 30 Apr 2012 14:50:06 GMT

Thank you very much Jo-Anne for your answer, i tried it on a simple substract between two dates and it's working perfectly, but now i have one more complicated one to realize, i tried to do the same method but it didn't worked, it will be awsome if you can help me with this one i'm try'in to do this in my field : (Today() - PlannedStart) * Amount / ((PlannedStart) - PlannedEnd + 1) how can i do it Thanks a lot

Re: substract two dates to have days

Jo-Anne Alfafara — Mon, 30 Apr 2012 14:30:02 GMT

Hi,

InfoPath doesn’t have a function that will return the difference between two dates. For cases like this, we use a tool called qRules – it has a command called DateDiff that will simply calculate the difference for you.

Meanwhile, you can also do it the long way by adding rules to your form – see sample attached.

Hope that helps!

Jo-Anne

substract two dates to have days

walspec — Mon, 30 Apr 2012 11:52:04 GMT

Hello, can you provide me please with a formula( not XPath coded because i found a script wich is not working) to substract 2 dates in infopath to have result in days Thanks a lot