Hello ---

I have 2 tables that I need to connect to represent my date field differently.

The first table (TERADATA) shows a sales date along with a bunch of other information.

The second table (EDW) is a breakout of the accounting calendar (Week, Month, Year, etc) for each date.

I need to display the week, month and year based on the sales date from the first table. However when I do that I get the infamous asterix for my data. What am I doing wrong?

Thanks!