View Single Post
Old 04-30-2017, 05:42 PM   #7
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,820
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@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
BetterRed is offline   Reply With Quote