|
@rellwood - maybe this will work.
Add a custom column of type Column built from other columns with a template that formats the date as year, month and day (e.g. 2017-05-01), then in Bulk MDE Search and Replace append that column to a Tag like custom column. Tag like columns can have multiple values, won't allow duplicates, and will display the values in a sensible order.
I'll leave you to work out the custom column template and the Bulk MDE S&R spec (once you have one that works you can save it for later reuse). IIRC the manual has some examples for dealing with dates in templates, and the Mode parameter in Bulk MDE S&R has an Append option.
BR
|