In tableau i am trying to create a code that helps with these items:

If resolved date > target end date then this will be labeled as a "Miss"

if resolved date <= target end date then this will be labeled as a "Met"

and all other null values will be labeled as a "Miss"

I had this code at first but it didn't bring in all the nulls that were on the table

IF [Resolved] > [Target End Dt] THEN "Miss" ELSEIF [Resolved] <= [Target End Dt] THEN "Met" ELSE "Miss" END

any help is appreciated! i tried a case statement but i don't want to use exact dates