Combine date columns

louiswatson
louiswatson
in Beast Mode

Is the below logic possible?

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

Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    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.

Categories