This content has been marked as final. Show 2 replies
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'
Any help would be greatly appreciated.