ms2007 date recognition problem

[Norm Sund]

I have a database made in ms 2003, i installed ms2007 and now the querry does
not recognize dates in the year 2010.... anyone have similar problem and find
a solution?... in 2003 i enter date as 09012009, for sept 1 2009, when i put
in the date in ms2007 after 12312009 it says error on my report ( no error
number)
example of date enter for year 2010 is 01012010

 

[John W. Vinson]

I have a database made in ms 2003, i installed ms2007

What are ms2003 and ms2007? Are you referring to Microsoft Access, or some
other program?

and now the querry does
not recognize dates in the year 2010.... anyone have similar problem and find
a solution?... in 2003 i enter date as 09012009, for sept 1 2009, when i put
in the date in ms2007 after 12312009 it says error on my report ( no error
number)
example of date enter for year 2010 is 01012010

These are not Date/Time formats. What in fact is the Datatype of the field?
Text, Number, Date/Time (with a mmddyyyy format), something else?