E-Mail Addresses

Adam Eggert

Is there a way to query e-mail addresses that were added to the database within the last month?


Thanks,


Adam Eggert

Foundation Database/Development Assistant

Horizon Health Foundation

Aaron Rothberg

I don't see a way to restrict a query to Date Last Changed for phones, but Date Last Changed for phones exists in Export. You could output all phone numbers in the database along with Date Last Changed, sort by Date Last Changed and find phone numbers changed in the past month.

Alan French

Date Last Changed is available in queries, it's before you drill down into the Specific Phones node. It doesn't necessarily tell you that the email was added on that date though; someone could have changed an existing email address in some way.

Aaron Rothberg

Ah, so it is! Thanks Alan. And my bad for referencing Date Last Changed since the question was about addresses being added, not necessarily changed. You can ignore everything I've posted in this thread.

 

¯\\_(ツ)_/¯