Collapsing >1 Row In 1 Field Into 1 String

[lucasdavis500]

I'm looking for advice on how to collapse multiple rows from one field into a single string in a text box. I thought I had done something similar to this before, but haven't used QV in quite a while since my application was developed and I believe I removed it.

My data looks like this

Date                   SLA

1/1/2017               0

1/15/2017             0

2/1/2017               1

2/18/2017             1

I want to use a text box to show all of the dates where the field SLA is '0' separated by some delimiter

E.G.

Value in TextBox shows:

1/12017 1/15/2017

[marcus_sommer]

Try: concat({< SLA ={0}>} distinct Date, ' + ', Date)

- Marcus

[sunny_talwar · Accepted solution]

Try this

Concat(DISTINCT {<SLA = {'0'}>}Date, ', ')

[lucasdavis500]

Thank you, both answers seem to be correct.