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?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey Not Submitting Due to 24 hour Time

LeviCecil

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?

Find more posts tagged with

Accepted answers

All comments

Lei_Liu

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

DavidPike

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).

LeviCecil

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

LeviCecil

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

dougbrowning

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

LeviCecil

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.

Screen Shot 2025-03-19 at 9.27.53 AM.png

LeviCecil

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

LeviCecil

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?

LeviCecil

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

Andrew_McClary

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.