@stevew I’m trying to keep tickets and all related transactions in the same work period. I’m intentionally doing this. So the date range on your sql script will not filter payments made in that time range. It will list payments made for tickets that got created in that range.
This post may give an idea about a possible solution.