I'm trying to run a dynamic relative list of contributions processed yesterday, regardless of order date.
My silly work around was to use Acknowledgement Request Date, which if I understand the documentation on "Acknowledgement Date", it's the date the acknowledgement was added, i.e. transaction date. The query shows trn_dt as well. However, it seems like this criteria is still using the order date. I checked the contribution screen on my test case and do see that the acknowledgement date matches transaction date, and not the backdated order date. But, when I play around with the relative dates, it only finds rows that match the order date.
Is this functioning as it should? If so, beyond creating a custom list criteria, does anyone else do something similar? My goal is to add attributes to the household and Adult Members using a scheduled daily Manage Attribute utility.
Thanks so much for any help in advance!