In a lookup field of a record linked to many records, I have a large string of dates. They are in no particular order.
e.g:
2024-01-09 4:30pm, 2024-01-04 7:00pm, 2024-01-08 2:30pm, 2024-02-09 11:00am, 2024-01-12 6:00pm, 2024-01-12 1:30pm, 2024-01-09 12:30pm, 2024-01-15 5:30pm, 2024-01-12 12:00pm, 2024-01-10 12:00pm, 2024-01-16 5:30pm, 2024-01-18 12:00pm
How would I use a formula to refer to a separate date field(date only, no time), and create a new string with only dates from the large string that match the specified date?
e.g. If I specified "2024-01-09", for the data above this formula should return "2024-01-09 4:30pm, 2024-02-09 11:00am, 2024-01-09 12:30pm"
Thanks!
