nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report need for recent address updates by constituent code

Shevaun Brannigan

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

Find more posts tagged with

Comments

Dan Snyder

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

Shevaun Brannigan

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

@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

Shevaun Brannigan

Terrific, thanks very much!