Combine date columns


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

    **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.