How to select maximum date in ActiveRecord?

Question

Yii

YII2. There are a bunch of related tables, the question is what is the table with the product and the prices, you need to select products with a price with a fresh date in ActiveRecord
Table 1 product1
product2 table 2
date1 | product1 | Price date2| product1 | Price Date|Item2| Price table 3 need this date2|product1|price date|product2|price