topic Re: Survey Not Submitting Due to 24 hour Time in ArcGIS Survey123 Questions

Survey Not Submitting Due to 24 hour Time

LeviCecil — Tue, 18 Mar 2025 22:33:31 GMT

I'm in Enterprise 11.3. I have a survey that's passing the entered time to a time only field in the registered sde table. I don't think it likes surveys taken after noon, because I'm getting this error:

{"error":{"code":400,"extendedCode":-2147467259,"message":"Unable to complete operation.","details":["Invalid iso format: 15:25.","Unable to complete operation."]}}

Is there a calculation I can put in my XLS form to force the time field to send responses in 12 hour time?

Re: Survey Not Submitting Due to 24 hour Time

Lei_Liu — Tue, 18 Mar 2025 23:12:22 GMT

Hi LeviCecil,

The error message 'Invalid ISO format: 15:25' indicates a formatting issue.

For a detailed guide on valid ISO formats and other supported configurations, please visit our documentation here: https://doc.arcgis.com/en/survey123/desktop/create-surveys/decimaldatetime.htm

Thanks,
Lei

Re: Survey Not Submitting Due to 24 hour Time

DavidPike — Wed, 19 Mar 2025 00:31:48 GMT

Are you sure 12-hour time is the answer? have you tried a <12hr input that worked?

It seems more likely you have to specify the full time format. ArcGIS Pro and Online likely complete the rest if missing, but 123 and REST likes the complete object.

I'd try:

15:25:00 or 15:25:00.0

and/or run a GET on your existing service to see the expected format (enter a value in AGOL editor first).

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Wed, 19 Mar 2025 16:51:36 GMT

Ah OK. When will these fields be "fully supported?" It says they're beta functionality at 11.2, but we're at 11.3

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Wed, 19 Mar 2025 05:36:03 GMT

I’m not using AGOL, this is in Enterprise 11.3. The thing is, I submitted several surveys before these errors started happening. The last one was at 1:18pm, which would have been 15:18

Re: Survey Not Submitting Due to 24 hour Time

DougBrowning — Wed, 19 Mar 2025 16:07:14 GMT

I do not think 123 supports the new time only fields yet. Not positive but I would check into that.

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Wed, 19 Mar 2025 16:52:29 GMT

Well, according to the link above, it's beta functionality at 11.2. Not sure if it's fully supported at 11.3. Probably not. Two surveys I submitted yesterday after 1pm went through to the table and had the seconds formatting. After this it started failing. I'll try adding formatting in the XLS sheet.

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Wed, 19 Mar 2025 18:28:08 GMT

In which column in the XLS form do I specify the time format, like ISO 8601?

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Wed, 19 Mar 2025 18:49:53 GMT

I just discovered that this is only an issue in the web survey. A survey submitted through the S123 app returns hours, minutes and seconds. I read that the web app version only works with decimal time. Where do I specify this in the XLS form?

Re: Survey Not Submitting Due to 24 hour Time

LeviCecil — Mon, 24 Mar 2025 17:05:13 GMT

Is there an expression to force the survey into decimal time in the S123 Excel sheet?

Re: Survey Not Submitting Due to 24 hour Time

Andrew_McClary — Mon, 23 Mar 2026 23:21:59 GMT

Did this ever get resolved/answered? I'm dealing with the same issue where it works fine in the field app but it doesn't work in the web form. Also on enterprise.