Get a list of accounts where they were reactivated in a week

(0) Share

Report

Posted on by eddoria01

I would like to get an advanced find query where I can list all accounts which were inactive but then reactivated in a rolling week. This is so I can create distributed activities for these accounts which are missing activity as they were inactive when the original distribution was created. Thank you for any pointers. This advanced find query would be run each week hence I need a dynamic week period.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

Hi eddoria01,

Since accounts will eventually be activated, the difficulty is: how to determine which accounts were previously inactive and when the status changed.
You will need to make some customizations to this:

1.Create custom fields to store whether to reactivate and the date of the change.

2.Use workflow to update these two fields automatically.

--First update action:

Advanced Query:

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No