Expand my Community achievements bar.

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
Level 6

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

2 Replies

Avatar

Correct answer by
Level 6

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.