Thanks! -- Kathryn > -----Original Message----- > Kathryn, > Set the options like this:
BTW, John, there were 7 people it didn't work for (I found them in TMG by filtering the PE for Name-Marr date field not empty). All 7 were "between" dates. No problem deleting those dates by hand, but thought you should know that ^.*$ didn't quite get rid of them all, though close enough - lots better than the 754 there were before. -- Kathryn > > -----Original Message----- > > Kathryn, > > Set the options like this:
Kathryn, I cannot explain why 7 were skipped. The "between" shouldn't matter, "^.*$" matches all characters except newlines. Probably not worth worrying about. John
I wrote: > I cannot explain why 7 were skipped. Oops. Yes, I can explain it. The help for TMGU's Find and Replace says: "Find and Replace will not modify regular dates that contain date ranges. Date range dates are "from-to" dates, "between" dates, and "date or date" dates." The issue is that Find and Replace can't convert date ranges back to regular dates, so if you were just changing the date, rather than removing it, it wouldn't be able to change the date and restore it to a "regular" date. For that reason, Find and Replace ignores date fields that contain date ranges. John