Just replying to add some text here to make this a bit more findable. This is an awesome post. Thanks for helping out the community Steven!
Teradata Invalid operation for DateTime or Interval.
Thank you for sharing this! I hope it helps another user who might come across this behavior.
I would also encourage you to create an Idea for Tableau to automatically detect and handle data type changes such as this.