Concat time fields?

ChadC — Fri, 08 Sep 2023 17:49:37 GMT

I am attempting to concat two time field(s) to a text field so the end user can populate business hours. When I preview the expression in Survey123 Connect, I am able to see the range of business hours (24 hr clock), as expected. However, when I publish the Survey to AGOL (and open it in a web browser), I am getting an error: 'Invalid Date' - 'Invalid Date'. This is puzzling!

concat(format-date(${morninghrs}, '%h:%M'), ' - ', format-date(${eveninghrs}, '%h:%M'))

I have also made attempts to concat the function with the following expression:

concat(string(format-date(${morninghrs}, '%h:%M')), ' - ', string(format-date(${eveninghrs}, '%h:%M')))

Any help would be greatly appreciated!

Re: Concat time fields?

ChipMorgan65 — Tue, 12 Sep 2023 15:14:41 GMT

Hi,

I'm unsure why the web version of Survey 123 is behaving like this.

A possible workaround could be to use two text fields to set the starting and ending hours as opposed to computing them from dates. You could use a pair of select_one questions that share a common set of choices for the hours of the day. This would simplify data entry and improve data quality. Admittedly, this might not work for your situation.

topic Concat time fields? in ArcGIS Survey123 Questions

Concat time fields?

Re: Concat time fields?