I have custom Oracle SQL returning a number of columns including a Timestamp "Due date".
The source data has some typos where the date has been entered incorrectly so as to be a syntactically correct data but wrong by a few centuries Tableau seems to struggle.
In some circumstances e.g. Year(), Month() etc Tableau seems to work with these dates but in others e.g. ATTR() it does not, yielding an "⌗Error"
Can anyone explain?
6 answers
Hi Andrew,
Here is a good thread that explains what you are seeing and plausible workaround (my comment and Lukaz workbook):
Using dates before 00/00/0000 in tableau
In short: Tableau doesn't handle dates before 400 AD.
Regards,
Gerardo
