InfoPath Dev

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

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

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