We told him that there wasn’t a way that we knew of, but he didn’t give up. Below is his solution:

I finally figured out how to use variables in Koha SQL so you don’t have to have staff repeat parameters. Here is an example where I had to use the same date in two places. Rather than asking for the same date twice, I use the variable @TargetDate: