1 of 1 people found this helpful
This is likely to be due to some sort of discrepancy in locale/regional settings. Teradata might be configured to understand 'YYYY-MM-DD' format implicitly, but Tableau or its Teradata driver might not.
Can you use explicit conversion to date, something like TO_DATE('2013-07-21','YYYY-MM-DD') instead of the date text? I don't know Teradata SQL syntax, so I used Oracle as an example.
Thank you Dimitri! After posting this, I tried casting calendar_date to DATE and I was able to got it working:-
CAST(calendar_date as DATE) = '2013-07-21'.
Appreciate your quick response!