date key issue

[Sam_1985]

I try to map the key from d-date table to the d-patient with common date and I put the same date format for both dates even though the key not mapping . screen shots are attached

how to solve the issue????

[BrunPierre]

Maybe FILE_REGD_DATE is not properly formatted in both tables.

Try with these

 Num(Date#(FILE_REGD_DATE, 'MM/DD/YYYY'))

or

Date(Date#(FILE_REGD_DATE,'OrginalFormat'),'MM/DD/YYYY')