It is returning some funny results, I believe it is because I am searching the Maximum date whereas I should be looking individually each transaction date