1 Reply Latest reply on Feb 11, 2013 8:59 AM by Rey Sanchez

    Date Relationships

    Jesse LaBoda

      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!