I have two tables. One was created in excel, Table1, the other is an attribute table associated with a shapefile, Table2.
I want to join Table1 and Table2 into a single table, using the day of the year. When I try and run the "Join Field" tool, Table3 contains all the information from Table1, but Table2's time values have all been changed to midnight. When I perform a temporary join, it works just fine. I tried turning Table1's 'Date' from a string to a date, so it would match Table2, but it didn't fix anything.