by I have a database called Last_Contacted.FP5 that contains these key
fields (Along with many others):
Unique ID
Company Name
Address
City
State
Zip
Last Contacted
Each time the user contacts this company, the Last Contacted date is
updated for the date that the record was altered.
What I am trying to do is to run a script that will look at the "Current
Date" and match it to the Last Contacted date. If the
dates match, then I want it to copy all of the data elements listed
above to another database called. Records_Updated_History.FP5.
How do I do this ?
-S