Scenario: If we need to find the latest date/the recent date among the three dates in a saved search, use the following formula in the search criteria.
Formula(Date): CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_second_expiry_date},{custrecord_project_first_expiry_date})) THEN (CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_third_expiry_date},{custrecord_project_first_expiry_date})) THEN {custrecord_project_first_expiry_date} ELSE {custrecord_project_third_expiry_date} END) ELSE (CASE WHEN ({custrecord_project_second_expiry_date}>= NVL({custrecord_project_third_expiry_date},{custrecord_project_second_expiry_date})) THEN {custrecord_project_second_expiry_date} ELSE {custrecord_project_third_expiry_date}END )END