Join time field type within a repeat to note field

[GeorgeClutterbuck]

I am recording a number of observations within a repeat. I can then create a summary of the results using the join calculation for most fields, but I can't create a list of times from the time field. How would I go about joining them to a new field? I have attached a screenshot which will hopefully be clearer. Thanks.

[DougBrowning]

My guess is that it not being a string is causing the issue.  Have you tried a hidden field that uses this formula and then do a join on that field?  You can sent the bind esri column to null so these temp fields stay out of the feature service.

format-date()

Fits an existing date or time value to a defined format.

format-date(${previous_time}, '%H:%M')

Hope that works

[abureaux · Accepted solution]

@DougBrowningIs correct. It's a super strange limitation, but you cannot use a date, dateTime, or Time field directly in things like join().

You first need to convert it using format-date(). For example, this is what I am using to display my time in a summary section outside of the repeat using join() on the calculate: