Jotform Submission Date/Time Problem

Like (0) Share

Report

Posted on 17 Jun 2022 19:28:55 by chrismassey

I keep running into an error when I try to adjust an incoming date field from a Jotform. Jotform, for some reason, doesn't send a time zone with their date field, so in order to get it to land on a calendar correctly, I've been using addhours to do the adjustment. This worked without a problem until suddenly it didn't. No change was made to the form or the incoming data - it still shows up in the incoming feed. If I try to run the flow without adjusting the date/time, it lands on the calendar, just several hours off of the correct time. Now, when I apply the addhours expression to the dynamic incoming date, it errors out and says that it is expecting a string value and is getting a null one. It's not a null value - it shows up correctly in the incoming data. What am I doing wrong?

All responses (2)

Answers (0)

takolota1 4,923 Moderator on 21 Jun 2022 at 01:03:19

Like (0)

Report

Re: Jotform Submission Date/Time Problem

@chrismassey

I dealt with this soooooo many times with JF. It should be a simple fix though.

Just set anything like that with an expression like…
if(empty(DateDynamicContent), ‘’, DateWithNonNullExpressions)
chrismassey 2 on 17 Jun 2022 at 19:40:45

Like (0)

Report

Re: Jotform Submission Date/Time Problem

Here's a ridiculous twist: other dates and times in the form work with addhours just fine. It's just the one field I actually need it to increment the time that it fails on.