convert from text to date

D

dchristo

In a table I have a text field that contains a date "20070101"; in my query
is there a way to convert that from 20070101 to 01/01/2007 and make it a date
field.

Thanks
 
K

KARL DEWEY

Try this ---

DateSerial(Left([YourField],4),Right(Left([YourField],6),2),Right(Left([YourField],8),2))
 

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

Imported Date Format 3
Convert Text To Valid Date 4
Using DateAdd and IIF conditions in a Query 2
SQL connection string giving type mismatch 3
Help please! 3
Updating a coumn in Excel based on new entry data 1
Checking a database/excel sheet for new entries 2
Convert date serial from text to date value 4

Top