Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

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?
0
gcgcit
Asked:
gcgcit
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now