2 Replies Latest reply: Jul 4, 2017 9:26 AM by Donna Crossan RSS

    Date fields in a Composite Key

    Donna Crossan

      Hi all,

       

      I have created a composite key which includes the date field ,interval and calltypekey however the dates are not appearing the same in both tables resulting in my data from the two tables not associating correctly. I believe this is a Date formatting issue but both date fields are 'Date' in the SQL Server.

       

      I have tried date() and Date#() but neither have worked.

       

      I need the comp key and date to match what is in  'AggData'

       

      AggData

       

      Date Problem.PNG

       

      OrgData

       

      Date Problem 2.PNG

       

       

      Any help would be greatly appreciated.

       

      Thanks,

      Donna