Skip to main content
blue_monkey1
Level 2
Oct 22, 2019 3:55 PM UTC
Solved

Finding Min Date from Multiple Columns

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Raj_Ganta-1
    Raj_Ganta-1Accepted solution
    Level 5
    Oct 22, 2019 4:55 PM UTC

    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 reply

    2 replies

    blue_monkey1Author
    Level 2
    Oct 23, 2019 8:03 AM UTC

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

    Translate
    Raj_Ganta-1
    Raj_Ganta-1Accepted solution
    Level 5
    Oct 22, 2019 4:55 PM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...