Is there any way to create a query of  addresses changed during a certain time period?  I just want the preferred mailing address, not phone or email.

Thanks much,

Melinda

In Query under Addresses, Preferred Address, there is a field called "Preferred Address Date Last Changed." This would give you the preferred address as a whole, though.

There are certain limitations when you need information retrieved through Raiser’s Edge interface. Last Date Changed is one of them. When you try to select or display this field, the information you get is the value of last date changed of either address or phone numbers associated with that address.

Since addresses and phones are stored in the separate tables, they both have columns LAST_DATE_CHANGED. Therefore, when address gets updated, value of LAST_DATE_CHANGED from ADDRESS table gets updated, as when phone gets updated the value of LAST_DATE_CHANGED from PHONE table gets updated…

One way to get information you need is to connect to your RE database directly via Crystal Reports or use SQL Query.

 Thank you for the help!