Date not being imported.

[Gatorajc]

I'm trying to import data from a text file. The only problem I am having is that I have two date fields side by side. One is to track when an item was sent out and another when the item is returned. The first date populates correctly but the second for some reason does not populate. All other fields before and after show correctly. Any ideas? AJ
I would lose my head if it wasn't attached.

 

[sleipnir214]

I assume that your import uses LOAD DATA?

What is your field delimiter? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Gatorajc]

figured it out thanks, the format was in mm/dd/yyyy and it was throwing it off when it tried to import it. Its fixed thanks anyway.
AJ
I would lose my head if it wasn't attached.