Thanks Peter, much cleaner.

Sorry the transaction date is in the original table. I did get a solution, by just doing nested select statements, rather than derived tables, I only had to declare the variables...