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.
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.