Trouble Converting Text to Data/Time

I have 1400 hundred records in a table that is store as text but the information is actually dates:

format: 01/30/95

When in design mode, I'm trying to convert the table data type but it says two records would be deleted because they don't contain correct date/time data.  Wondering, is there some sort of query I could do to find the two records and manually update them?  I've eyeballed the data but I'm going cross-eyed trying to find the date that is invalid.  There has got to be an easier way right?
gcgcitAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this query

select fieldName from tablex where isdate([fieldname])=0
0
 
Rey Obrero (Capricorn1)Commented:
you can  try this one too

select fieldName from tablex where isdate([fieldname])=0 or len([fieldname])<>8 or instr([fieldname],"/")=0 or [fieldname] & ""=""
0
 
gcgcitAuthor Commented:
You're not an expert you are a genius! Thanks!
0
 
gcgcitAuthor Commented:
Used the first one posted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.