Include Query Output Field "Last Gift Soft Credit Date"

It would be extremely helpful and useful to be able to export the "Last Gift Soft Credit Date" field within query, specifically a constituent query. We're mapping data from Raiser's Edge to Importomatic-MailChimp. The query criteria needs to pull constituents who are included on our MailChimp email list, and the Output tab of the same query needs to include the fields we intend to use in MailChimp (either for internal sorting purposes OR for merge fields to include within emails to constituents). Without having this field available, we're unable to accurately represent the Last Gift Date for spouse records or for donor of Family Foundations. I'm curious why this field doesn't already exist (as nearly all other commonly used Soft Credit fields are available for inclusion)?  

Thanks for your consideration!

  • Guest
  • Sep 26 2017
  • Attach files