Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Max of Two Dates

MadeInHB
8 - Asteroid

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 ReceivedPayment Posted
2/1/20172/5/2017
2/15/20172/16/2017
2/17/20172/10/2017
2/20/20172/1/2017
2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MadeInHB
8 - Asteroid

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!!!

Labels