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 |
Solved! Go to 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
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!!!