Max of Two Dates

[MadeInHB]

So I am probably making this harder than it should be, but I have two fields that contain dates.  Lets say Payment Received and Payment Posted.  Payment might be posted prior to the information of the Payment Received is.  I am trying to compare the two dates and return the max of the two into a new field named Aging Date.  Thanks!

Payment Received	Payment Posted
2/1/2017	2/5/2017
2/15/2017	2/16/2017
2/17/2017	2/10/2017
2/20/2017	2/1/2017

[MarqueeCrew · Accepted solution]

Max([Payment Received],[Payment Posted])

The dates however need to be formatted as:

MM-DD-YYYY

You can leave them as is or translate them with a formula like:

Max(
     DateTimeParse([Payment Received],"%m/%e/%Y"),
     DateTimeParse([Payment Posted],"%m/%e/%Y")
)

Make sense?

Cheers,

Mark

[MadeInHB]

Makes sense and worked flawlessly.  I was overthinking the logic way too much.  

And I did have the dates in the Alteryx format.  I just used excel as the example.

Thanks!!!