How do I translate text field into date in ACCESS Query

  • Thread starter Thread starter Guest
  • Start date Start date
If the date information was entered correctly, you should be able to open the
table in design and change the data type to a "Date/Time" instead of "Text".
I would make a copy first to make sure it all translates properly first.
 
How do I translate text field into date 0104--> 01/01/
Click to expand...

01/01/ isn't a date, and I don't see how it can be derived at all from
the text string 0104.

What calendar date does 0104 refer to? What are some other examples of
your "non-date dates"?

John W. Vinson[MVP]
 
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

Using DateAdd and IIF conditions in a Query 2
Access Running Balance in Access 1
Populate a table 2
Date Formatting 1
convert from text to date 1
Conditional Sum in a Form 7
Date Format when Exporting 5
Convert Text To Valid Date 4

Back
Top