Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Date Problem

Status
Not open for further replies.
daver676

daver676

Programmer
Joined
May 21, 2003
Messages
4
Location
SG
Hello!

My table gets it's records from a text transfer. One of the fields is a date that comes into the table in YYMMDD format. The data type of the field is text. The date/time type screws up the date and causes import errors. My question is how can I format the date once it's in the table? Or can I use a query or macro? Please be specific, I'm new at this. :)

Thanks

Dave
 
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question Question
Getting the Monday date from a week number
Replies
2
Views
1K
TomSalvato
TomSalvato
visitnag
  • Locked
  • Question Question
combo box entries problem
Replies
8
Views
761
visitnag
visitnag
Dophia
  • Locked
  • Question Question
Problem using code to open a form, but works to open a report
Replies
1
Views
330
dhookom
dhookom
nikademous
  • Locked
  • Question Question
Go to specific Record based on date
Replies
0
Views
226
nikademous
nikademous
PWD
  • Locked
  • Question Question
Access 2010 Sort By Calculated date
Replies
7
Views
443
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top