So I was using a query with format to format a date. I fixed the issue because I noticed I put 3 y's instead of 4 for the year but I was getting and odd result and was wondering how access got to this point?
Actual date: 9/30/2022
What Access returned: 09/30/22273Code:Format(DateUpdated,'mm/dd/yyy') '3 y's instead of 4
Does anyone know how Access turned 2022 into 22273?
Note: I don't believe it matters since it isn't modifying that field but there are some inner joins and other fields in the query.
Access 2019