Importing from access

I have an access table with multiple data fields. When I add the fields into my crystal report all of the data fields show data except the date field.

I then imported the same table into a ms querry and the date field pulled the data in excel.

So there is data when I pull it into excel, but none when I pull it into crystal.

Any suggestions?Check the settings for --> File / Options / Fields / DateTimesql