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?