Report need for recent address updates by constituent code

Hi!

I am seeking to pull a report of all alumni who have recently had their addresses updated in our database (so as to distinguish from outdated addresses). I'd like to run a report but I'm unsure if RE has the capability to track the recency of a change in that level of detail.

Can anyone offer some guidance? (Or other thoughts on approaching this challenge?). I know you can look at a record and see the last change made, but am unsure beyond that. I am a relatively new user.

Thank you very much,

Shevaun Brannigan

Comments

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions Commented in Discussion

    @Shevaun Brannigan In database view there is the field, date last changed that you might be able to use for this.

  • Thanks very much, Dan! I know of that field--it's not quite what I need but I thank you very much for answering, and in the meantime I figured out a workaround. So I am all good!

  • Faith Murray
    Faith Murray Community All-Star
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Shevaun Brannigan, there is a field in database view for Address "Date Added" or "Date Last Changed." This is different from the Constituent "Date Last Changed." (See below.) So, you could combine this with

    • Address Date Last Changed greater than …
    • AND constituency equals Alumnus

    Is this what you were looking for?

    00dfbd219d42477abac213d91b8c4db0-huge-im
  • Terrific, thanks very much!

Categories