Date fields in a Composite Key

[#1]

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

OrgData

Any help would be greatly appreciated.

Thanks,

Donna

[Gysbert_Wassenaar · Accepted solution]

Try using the num function to turn the date strings of the AggData table into numeric values like in the OrgData table. If that doesn't work then they're not dates but strings. In that case use num(date#( Date2, 'DD/MM/YYYY'))

[#3]

This works Thank you !

I was able to change it within the composite key.

Thanks for the help