Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
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')