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

SOLVED

Finding Min Date from Multiple Columns

blue_monkey1
Level 2
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
Raj_bounteous
Correct answer by
Community Advisor
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

2 Replies
Raj_bounteous
Correct answer by
Community Advisor
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

blue_monkey1
Level 2
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.