That's because if you're only importing the value 2006 into Tableau, it has no way to know which date this is. It is an inetger. If you need to convert it to a date you'll need to create a calculated field, something like DATE('01-01-' + STR([YearField]))
Good morning Andrew,
Thank you so much for the help - it worked.
I appreciate your time and effort.
I used the calculated field you showed(DATE('01-01-' + STR([YearField]))) to convert a year from a string to date. It worked when data was in excel. Now when the data was migrated to Oracle - it gives a database error .
Oracle database error 1843: ORA-01843: not a valid month
Please, can you help.