That’s easy enough to put together using the extremely useful
DATETIME_PARSE() twins. The secret is using the rich set of format specifiers both functions support.
For instance, to create a datetime value equal to 5 pm on the day following the day on which a record was populated by a form submission, you could use this formula:
That might not be what you want, though — for instance, it means a form submitted at 11:59 PM on January 1 would have a due (?) datetime of 5:00 PM on January 2. If you want to set a cut-off time for submissions, you’ll need to add an
IF() clause to tweak
DATEADD() into adding either one or two days, depending.