Is there anyway to scriptomatically change a date field in a contacts database? We have one that decided to put “01/01/4501” in the birthday of all the contacts (we don’t even use that field). I’d go through and change them manually but there’s over 14000 contacts in it. Any ideas? Thanks!
Subject: Scriptomatically change the date in a contact database
If you simply want to remove the value from that field (since you said you don’t use it, and the previous script wrote the same value to it). You can create a formula agent with one line of code:
FIELD YourBirthDayFieldName := “”;
If you want to remove the field altogether;
FIELD YourBirthDayFieldName := @Nothing;
Put either lines in an agent and set the agent target to run on selected documents (the default target). Go to a view select all 14,000 and let it rip…
Although I’d just test on one just to make sure.
Mike Robinson
Subject: RE: Scriptomatically change the date in a contact database
Dude. You rock. Worked perfectly! Thanks!
Subject: Excellent!