I have an append query that is writing a strange date value to a field in the table it is appending.
Here is what the query designer looks like:
But when the date which is 2018 in the original table gets exported it looks like 7/10/1905 in the table that is appended. I want it to say 2018.
Why is this happening?