Combine date columns

Is the below logic possible?

If appeal determination date is blank, insert determination date, if not insert application determination date?

Tagged:

Answers

  • If by blank you mean null, then you can use the IFNULL() function to do the replacement ilke this:

    IFNULL(`appeal determination date`,`determination date`)
    

    If it isn't actually null but an empty space you can do this:

    CASE WHEN TRIM(`appeal determination date`) = '' THEN determination date
    ELSE appeal determination date
    END

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.