InfoPath Dev

Hi is it possible to add like 12 hours once you extract the time from now() function?

Use the addSeconds function - but I'd probably add that first, then use substring-after to get the time. See attached - save the file locally, right click & select Design. Formula is: addSeconds(now(), 43200)

Hilary Stoupa:

Use the addSeconds function - but I'd probably add that first, then use substring-after to get the time. See attached - save the file locally, right click & select Design. Formula is: addSeconds(now(), 43200)

is 43200 equivalent to 12 hrs? so for example the date now and time is Sept 7 11PM so if I add that function it will become Sept 8 11AM?

Yup - did you see my sample form? You can just use Google to figure out the math.... but if you need to do it in your form (like, user types in the number of hours) you can multiply the field with the hours to add by 3600, which is the number of seconds in an hour.