InfoPath Dev

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

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.

 

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

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