So I created the following field
DateIntoSystem: [DateIntoSystem]
But when I click on "Make Table", I prompt box comes up and I enter 06/20/2012 as the Date
But the table that gets created, the Data Type in the Table is Binary. I want it to be Date/Time.
I also changed the format in the Property Sheet to Short Date.