Issue with append queries

Hello, I attempted to append two queries that share the same columns, intending to add rows of data from the second table to the first. However, I encountered an issue with the date column. Power Qu...