We are trying to use TO_DATE in a IN clause and the syntax checker does not seem to like it. Here are some examples:
Don't ask me why, but Teradata doesn't allow any kind of calculation or function within IN.
Thanks Dieter. Technically is allows the calculation for one value but not for multiple. Hopefully they will fix it soon