General

Re: How to substract time in infopath

Abhishek.kk — Sun, 27 Oct 2013 06:33:12 GMT

Hi, Thanks for reply. Here is what i want to do:- I have created three text boxes, where people will paste a value in first text box in this format - (10/24/2013 5:52:36 PM) specifically Now the other two boxes should automatic calculate time as :- 2nd text box - 10/24/2013 5:52:36 PM - 2 hours = 10/24/2013 3:52:36 PM and 3rd text box - 10/24/2013 5:52:36 PM - 6 hours = 10/24/2013 11:52:36 PM. Regards Abhishek

Re: How to substract time in infopath

wilkies0106aw — Fri, 25 Oct 2013 07:41:15 GMT

Obviously if you want to take away 2 hours add a minus sign in front of your seconds - addseconds(substring-after(now(),"T"),-7200)

Re: How to substract time in infopath

wilkies0106aw — Fri, 25 Oct 2013 07:38:29 GMT

You might want to separate the date and time into 2 fields.

You could use the addseconds function, if you consistently wanted 2 hours.

i.e. addseconds(timefield),7200)

you could also do something like the following addseconds(substring-after(now(),"T"),7200) if you used the now function.

Anything more complicated you'll most likely need other fields so that you can do the math easier.

How to substract time in infopath

Abhishek.kk — Thu, 24 Oct 2013 19:12:23 GMT

Hi,

I am new to infopath. I created 2 text boxes. In one of them i will paste the time in "10/24/2013 5:52:36 PM" format. I want in other box the time should be :-

2nd box - 10/24/2013 5:52:36 PM - 2hours = 10/24/2013 3:52:36 PM GMT

Please help me with the same.

Regards

Abhishek