Find the maximum date before the selected period

I have tables as below Sales table with employe code, date, and sales amount Training table with employee code and training date. DateDim table - relationship with date in sales and training tabl...