I'm having an issue with a join in my query where the join are between two date fields. One of the table's date is formatted as mm/dd/yyyy. The second one is something like mm/dd/yyyy hh:mm:ss. How do I convert the second one in a query so that it matches the format of the first one? I thought format([MyDate],"mm/dd/yyyy") would work, but when I make the join, I get the error message of "Type mismatch in expression".