General

Re: Calculate date/time from three different fields

clawrence — Thu, 29 Sep 2022 18:13:55 GMT

Thank you, Hilary, you always come through!

Re: Calculate date/time from three different fields

Hilary Stoupa — Wed, 28 Sep 2022 19:57:56 GMT

Give the attached sample a try.... I used a default value to calculate the date time string from the fields, and you'll see I used some substring function to zero pad the hours field if needed. Then on the submit button, I compare that calculated field to now() + 1 to see if the datetime is > 24 hours away. Right click the linked file, save locally. Right click the saved file and select design. I haven't tested this in the browser, so you may want to give this form a quick test in the browser if you are using browser forms :)

Calculate date/time from three different fields

clawrence — Wed, 28 Sep 2022 18:45:12 GMT

Whew, it's been a while since I've had to be on here. Here's the problem I'm up against: working on modifying an existing form that has a date field (date), a start hour field (whole number), and a start minute field (whole number). I'm trying to calculate the full date/time with those fields so that I can then compare the field to now(). If that date time is not at least 24 hours from now(), I want to deactivate the submit button. Any ideas?