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:

Query Column
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?
SteveL13Asked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
hi Steve,

2018 is not a date. 2018 is a year and should be stored as an integer.  When converted to a date:

? cdate(2018)
7/10/1905

... and the reverse:

? clng(#7/10/1905#)
2018

have an awesome day,
crystal
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.