@theDBguy ,
The problem is that Access is making assumptions based on the values. If mmddyy is rational, that is the assumption. Look at the last one, the only rational interpretation is ddmmyy due to the individual values. but the one before that could be ddmmyy also but Access assumes yymmdd
print cdate(format("101130","00-00-00"))
10/11/2030
print cdate(format("101112","00-00-00"))
10/11/2012
print cdate(format("101022","00-00-00"))
10/10/2022
print cdate(format("221022","00-00-00"))
10/22/2022
print cdate(format("221021","00-00-00"))
10/21/2022
print cdate(format("221033","00-00-00"))
10/22/2033