I have 2 tables that I am trying to join. I am using date fields to join on. The problem is that the fields are formatted differently. What would be the best way to format them so I can join? Here are the outputs:
field name: report_date_run
5/12/2014 8:17:06 AM
field name: report_date
I am thinking I would convert table 1 to match table 2 "Report_date".