Hi,
I'm getting ⌗Error and Null values instead of dates under column 'Initial target date'.
Format for both 'Initial target date' and 'actual closure date' is same in source file(tableau prep). 'actual closure date' is showing up correctly.
Thanks in advance!
A
Hi @Atul B ,
This is happening because "Initial Target closure date" field is not in proper format and it contains both text and date information.
One alternative to create a date field from this field is as follows. This replaces the TBD fields with NULL value. For other calculations you can handle the NULLs accordingly based on the data requirement
IF [Initial Target closure date]='TBD'
THEN NULL
ELSE DATE([Initial Target closure date])
END
Regards,
Ajay
Please upvote and mark as Best Answer, if it helps you :)
