In Query, allow a date range to be applied to Largest Gift

I need an accurate query because I want to use it in a global change. I need donors' whose largest gift was at a specific amount DURING A SPECIFIC TIME PERIOD, NOT largest gift EVER at that specific amount. After doing the global change I will have to manually amend those records whose largest gift at the given amount was at a different time.

  • Guest
  • Jun 11 2018
  • Attach files
  • Art Bryman commented
    November 02, 2019 11:24

    FYI: While you can limit largest gift to a specific date range in an export, export will list the earliest gift (if there're more than one), not the latest.  There's also no option to sort by date.