Simplest way I know is to use dateSerial
I might prefix this with IsNumeric to test the string. And I might be
paranoid to test the string for length to make sure it is five characters in
length, but if you are confident about your data then you can just use the
above. Note that it will error if SomeField is null.
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County