Date conversion when appending an external file

  • Thread starter Thread starter Will Sellers
  • Start date Start date
W

Will Sellers

I have an external file with a date format of 99/99/yyyy . I need to
populate an access table with the date converted to mmddyy no slashes. How
can I do this? The input data type is text.The table data type is date/time
 
Hi Will,

Access date/time fields store the data in numeric form and you can display
it in any format you want. If you set the format of the field or textbox to
"mmddyy" you should see it the way you want.

When importing, mm/dd/yyyy usually works just fine (unless your Windows
short date format is set to "dd/mm/yyyy").
 
Back
Top