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?

[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

[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]

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

[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]

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. 

 

[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?