General

Re: Now() function

Hilary Stoupa — Fri, 06 Sep 2019 16:47:46 GMT

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.

Re: Now() function

erzon — Fri, 06 Sep 2019 16:24:48 GMT

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?

Re: Now() function

Hilary Stoupa — Thu, 05 Sep 2019 15:36:08 GMT

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)

Now() function

erzon — Thu, 05 Sep 2019 07:58:29 GMT

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