I am looking to create a status field IF [DateField1] IS NULL then "No Date" ELSE "Has Date" ELSEIF [DateField2] IS NULL then "Incomplete" ELSE "Complete" but I keep getting syntax error.

Question

I am looking to create a status field IF [DateField1] IS NULL then "No Date" ELSE "Has Date" ELSEIF [DateField2] IS NULL then "Incomplete" ELSE "Complete"  but I keep getting syntax error.

Nohemi West-Phelps · Accepted Answer

Thank you. I think I have figured out a way to combine them by saying -

IF ISNULL([DateField1]) THEN "No Date"

ELSEIF ISNULL([DateField2] THEN "Incomplete" ELSE "Complete"

END

I'll be missing the "Has Date" bucket but those would be captured under Incomplete or Complete.

DIEGO FERNANDO MARTINEZ RODRIGUEZ · Answer

@Nohemi West-Phelps​  Hi, in this case, I think you are mixing calculated fields. I guess you can create two fields: Status 1: IF ISNULL([DateField1]) THEN "No Date" ELSE "Has Date" END Status2: IF ISNULL([DateField2] THEN "Incomplete" ELSE "Complete" END If this does not work for you, could you give us some examples to understand what would be the input and expected output.   If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.   Regards,   Diego Tableau Ambassador

I am looking to create a status field IF [DateField1] IS NULL then "No Date" ELSE "Has Date" ELSEIF [DateField2] IS NULL then "Incomplete" ELSE "Complete" but I keep getting syntax error.

Tableau Desktop & Web Authoring

Related Learning

More Help