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

Dcount -Date Criteria - Won´t find it - 0
How to write a query/macro to consolidate data in the same table, anddelete the duplicate one 1
Text or number to short time. 2
Imported Date Format 3
Using DateAdd and IIF conditions in a Query 2
date in the form of yyyymmdd 2
Merge records with same number 0
Creating multiple text fields 0

Top