Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Finding Min Date from Multiple Columns

Avatar

Level 2

Can anyone help me find the minimum date of multiple columns per recipient? I have 7 date columns some of which are null.

Min-of-dates.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Maybe you can try to use a complex CASE function.

Case

Returns value 1 if the condition is verified. Otherwise, returns value 2

Case(When(<condition>, <value 1>), Else(<value 2>))

Ex: Case When Col1 < Col2 And Col1 < Col3 Then Col1
  
When Col2 < Col1 And Col2 < Col3 Then Col2
  
Else Col3

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Maybe you can try to use a complex CASE function.

Case

Returns value 1 if the condition is verified. Otherwise, returns value 2

Case(When(<condition>, <value 1>), Else(<value 2>))

Ex: Case When Col1 < Col2 And Col1 < Col3 Then Col1
  
When Col2 < Col1 And Col2 < Col3 Then Col2
  
Else Col3

Avatar

Level 2

I had thought of that initially but as 7 columns, I wanted to see if there was an easier solution. Thanks for your answer.