Sql_sap hana date calculation

All, please I need help with showing output of just 1 row of most recent Previous Date, New Date and Change Date.

This is based on the most recent CHANGE DATE(02/01/2025)

Output should be 03/05 2025 for Previous Date and 03/26/2026 for New Date.

All, please I need help with outputting only the most recent date. This will be based on the Most recent Change date