question on grabbing a date in a text box

[gerrycastellino]

I have a list of dates as below, with 4/30/2017 being the most recent/maximum date.

How do I grab in a text box a comma separated list of dates going back 12 months ?

[tresesco · Accepted solution]

Try expression like:

=Concat( Distinct {<Record_Date={'>$(=Date(AddMonths(Max(Record_Date),-12)))'}>} Record_Date , ',')