Determine which field has the newest date

[Njliven]

Please let me know if this is possible. I have two date fields in a record. I want the query to bring back only the most recent date from either one of the fields. So If date1 is more recent than date2, then show date 1 or if date2 is more recent than date1 then show date1. Seems feasible, just not sure how to write it to make it work. Nothing I have tried so far works. Thanks!

[JoeM]

Try:

MostRecentDate:IIF([DateField1]>[DateField2],[DateField1],[DateField2])

[Njliven]

Works! Thanks!