Composite Key with date

[madhuqliklondon]

Hi all,

I am creating a composite key to join two tables to get matching values. 

I am using below composition but it is returning only up to number, please correct me.

ID &'|'& Number &'|'& Date(Date#( DateTime, 'DD/MM/YYYY HH:MM:SS'),'DD-MM-YYYY') As _Key

Data: 

 [ ID, Number, DateTime

   22,564746474647, 15/07/2020 20:04:45

]

current output: 22|564746474647|

Expected output: 22|564746474647|15-07-2020

Thanks in advance

[Kushal_Chawda]

try below

ID &'|'& Number &'|'& Date(floor(timestamp#( DateTime, 'DD/MM/YYYY HH:MM:SS')),'DD-MM-YYYY') As _Key

[madhuqliklondon · Accepted solution]

This worked for me 

ID &'|'& Number &'|'& Date(Floor( Date(DateTime)),'DD/MM/YYYY') AS _Key

Thank you Kush for your support and time.