Start date and end date minus 1

[eric]

I have a start date and an end date. The calculation works. However, I need
it to subtract 1 from the total days. I used the following link to make the
original calculations.
http://enterprise-solutions.swits.n...e-date-difference-infopath-rules-formulas.htm
Where and what do i have to add for it to subtract 1 day from the total?

 

[Clay Fox]

Wow.
I had not seen that but that is pretty elaborate.

Typically I just add a bit of VBscript and the datediff function. You can
search on datediff at http://www.infopathdev.com and find some sample code.

I do not think you can reconstitue a date otherwise. if you have 2007 there
is a dateadd() function which I think you can add -1.

 

[S.Y.M. Wong-A-Ton]

The formulas in steps 2 and 4 calculate the difference in days, so if you
want the difference to be the difference minus 1, you just have to append -1
to each formula. For example, each formula ends with

- 32045)

Change that to

- 32045) - 1

 

[Edward VN]

I tried your 'Calculating date differences in InfoPath using rules and
formulas - no code!' but i cant get it to work, would it be possible to have
the finished form and i can work out what i have done wrong. Thankyou