Skip to content
+1-888-319-3663

COMMUNITY FORUM

Looking up the maximum of three dates in 365

Joseph Markovich asked 6 years ago
I am trying to use SmartConnect to find the maximum of three dates in the Opportunity entity of 365 and then update another field with the max date.
I’ve set up a change map on the Opportunity for the three date fields that could change — but now I’m stuck. I don’t know how I can look at the three date fields and find the max of the three.
Is this something that’s possible?
Thank you.
-Joe
Answers
Ethan Sorenson Staff answered 6 years ago
Joseph,
You need to use a calculated column with nested If statements to compare the dates to find the date that is the largest, and return that date. You can then map the calculated column to the column you want to update
 

If you would like to submit an answer or comment, please sign in to the eOne portal.