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.

Screenshot 2024-01-05 105416.png

abureaux

@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: