[AccessD] Date Format

I am having a problem formatting a Date of Birth when
the data uses the "mm/dd/yy" format

I want to use the following code

Format([PatDob],"yyyymmdd")

to format the data in the form required for another
application and everything works fine except when I
encounter someone born before 1930. My code turns
11/01/29 into 20291101
but it turns
11/02/30 into 19301102 like I want.

any suggestions?

=====
--------------------
Scott T. Gage
Scott.gage at promedica.org
419.291-7177

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com