Query - Find max date for each customer, if null take last previous transaction date, by month year

Hi,   I have a table with transaction dates for each customer. Then I have date table with dates, months, years.   I want to have a new table that will show for each customer his last transactio...