Why append query dealing with a date in a strange way?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.