Combine date columns

louiswatson

Is the below logic possible?

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

MarkSnodgrass

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