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").
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
converting text to date 4
Date Format Incorrect on Export 1
Import File Information 0
import mm/dd/yyyy hh:mm:ss AM date format 5
Problem importing dates 3
Date Format Question Again 2
Changing the colour of a cell after a specific date? 0

Back
Top